Cross-Join: All row by all row, ex: SELECT FROM , The Equi-Join or Inner Join:Syntax: SELECT FROM , WHERE (Table1.column = Table2.column) SELECT cds.artist, cds.title, genres.genre -> FROM cds, genres -> WHERE (cds.genreID = genres.genreID); The Left Join:Syntax: SELECT FROM LEFT JOIN ON Table1.column = Table2.column Without adding a WHERE clause the Left Join produces […]

Read more of this post