SQL Query #5

Lady Ikeya asked 3 years ago

When i try to run the inner join query on question 5, I keep getting the error message below., please help

Query typed:

SELECT lastname, firstname, locationcity
FROM employee
INNER JOIN location ON employee.locationid = location.locationid
WHERE state ‘GA’

Error message:
End of query expected but ”GA” found (line 4, column 13) WHERE state ‘GA’ ^

1 Answers
Justis answered 3 years ago

So you gotta have a = or LIKE in between state and ‘GA’

Your Answer

3 + 0 =