SQL Query #5

Lady Ikeya asked 2 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 2 years ago

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

Your Answer

1 + 0 =

css.php