I'm trying to join 3 tables together in a SELECT query with some WHERE clauses.
Table 1 is linked to Table 2, and Table 2 is linked to Table 3.
The tables are as follows:
INNER JOIN Author
INNER JOIN Location
The proper syntax is something like this:
SELECT a.Article_Name FROM Articles a INNER JOIN Author au ON a.Author_ID = au.Author_ID INNER JOIN Location l ON l.Location_ID = au.Location_Id WHERE au.First_Name = 'Sam' AND l.City <> 'Detroit';
Note the use of table aliases make the query easier to write and to read. Also, you need conditions connecting the two tables for the