Error message with SQL code

Question

I need some help with a code in MySQL server. I keep getting this error:

Failed to execute SQL : SQL

SELECT 
    CONCAT(INSTRUCTOR.FIRST_NAME, INSTRUCTOR.LAST_NAME) AS INSTRUCTOR_NAME, 
FROM 
    INSTRUCTOR 
LEFT JOIN 
    APPROVED_INSTRUCTOR 
    ON INSTRUCTOR.INSTRUCTOR_ID=APPROVED_INSTRUCTOR.INSTRUCTOR_ID 

UNION 

SELECT 
    CONCAT(INSTRUCTOR.FIRST_NAME, INSTRUCTOR.LAST_NAME) AS INSTRUCTOR_NAME, 
FROM 
    INSTRUCTOR 
RIGHT JOIN 
    APPROVED_INSTRUCTOR 
    ON INSTRUCTOR.INSTRUCTOR_ID=APPROVED_INSTRUCTOR.Instructor_ID;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM INSTRUCTOR LEFT JOIN APPROVED_INSTRUCTOR ON INSTRUCTOR.INSTRUCTOR_ID=APPROV' at line 1

I have double checked table and field names and done about an hour of research but everything I read indicates that there is not a problem with the code.

Any reason you tagged this with SQL Server as well as MySQL? — DavidG
– DavidG, Commented Mar 10, 2017 at 17:39

Ike Walker · Accepted Answer · 2017-03-10 17:39:58Z

2

Remove the comma after both occurrences of INSTRUCTOR_NAME:

This:

SELECT CONCAT(INSTRUCTOR.FIRST_NAME, INSTRUCTOR.LAST_NAME) AS INSTRUCTOR_NAME,

Should be:

SELECT CONCAT(INSTRUCTOR.FIRST_NAME, INSTRUCTOR.LAST_NAME) AS INSTRUCTOR_NAME

answered Mar 10, 2017 at 17:39

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kylegill · Accepted Answer · 2017-03-10 17:44:21Z

1

You don't need commas between the SELECT and FROM statements.

SELECT 
    CONCAT(INSTRUCTOR.FIRST_NAME, INSTRUCTOR.LAST_NAME) AS INSTRUCTOR_NAME 
FROM 
    INSTRUCTOR 
LEFT JOIN 
    APPROVED_INSTRUCTOR 
    ON INSTRUCTOR.INSTRUCTOR_ID=APPROVED_INSTRUCTOR.INSTRUCTOR_ID 

UNION 

SELECT 
    CONCAT(INSTRUCTOR.FIRST_NAME, INSTRUCTOR.LAST_NAME) AS INSTRUCTOR_NAME 
FROM 
    INSTRUCTOR 
RIGHT JOIN 
    APPROVED_INSTRUCTOR 
    ON INSTRUCTOR.INSTRUCTOR_ID=APPROVED_INSTRUCTOR.Instructor_ID;

answered Mar 10, 2017 at 17:44

kylegill

3141 silver badge12 bronze badges

Collectives™ on Stack Overflow

Error message with SQL code

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related