Administrator: Rave Reviews (Start) 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

Are the Tables Joined? Look at how these two tables are joined. There is an arrow going from the left table to the right.   The LEFT table, the small table of archived movies, is connected to the RIGHT table, the complete table of all of the movies in this database.   This is a LEFT JOIN. That means select ALL of the records in the LEFT table and select the records from the RIGHT table that EQUAL the records in the LEFT.     Memo to self: Queries "read" from left to right. Query Tools -> Design