View source for Portable SQL/Statements/Data retrieval/Join syntax

SQL supports several ways to join the rows of two or more tables.

== Inner join ==

 SELECT ''column-list''
 FROM ''table1''
 [INNER] JOIN ''table2'' ON ''table1''.''key'' = ''table2''.''key''
 WHERE ''conditions''

== Left join ==

 SELECT ''column-list''
 FROM ''table1''
 LEFT JOIN ''table2'' ON ''table1''.''key'' = ''table2''.''key''
 WHERE ''conditions''


----
Back to [[Portable_SQL/Statements/Data_retrieval|Overview]]