SQL Querying Multiple Tables: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
No edit summary
Line 4: Line 4:
* [[SQL_SELECT#Querying_Multiple_Tables|Querying Multiple Tables]]
* [[SQL_SELECT#Querying_Multiple_Tables|Querying Multiple Tables]]
=Overview=
=Overview=
Querying Multiple Tables, Joining Tables
More than one table can be used in a <code>[[SQL_SELECT#Querying_Multiple_Tables|FROM]]</code> query clause, and when that happens, it is said that the query performs a '''join'''.
 
 


Define join.


Join condition  
Join condition  

Revision as of 17:57, 23 May 2024

External

Internal

Overview

More than one table can be used in a FROM query clause, and when that happens, it is said that the query performs a join.



Join condition

Foreign key

Join