CODEWITHSUNDEEP
mysql
Victoria Widomski
Victoria Widomski

Reputation: 1

Error message with SQL code

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.

Upvotes: 0

Views: 53

Answers (2)

kylegill
kylegill

Reputation: 314

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;

Upvotes: 1

Ike Walker
Ike Walker

Reputation: 65547

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

Upvotes: 2

Related Questions