Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax.

I have three tables. Table 1 has 1 record, and joins to Table 2 on an field called ID which has 5 records. Table 2 joins to Table 3, which has 1 record. The only reason I'm linking in table 2 is ...