SQL joins . So far, I’ve described the SELECT syntax for single tables. Before I can explain JOIN clauses, you need to understand foreign keys and relations between tables.