Difference between revisions of "Talk:SQL Syntax Examples"
From Free Knowledge Base- The DUCK Project: information for everyone
(Created page with "== Best explanation of JOIN == *http://www.dofactory.com/sql/join File:sql-joins.png (INNER) JOIN: Select records that have matching values in both tables. LEF...") |
(No difference)
|
Latest revision as of 11:21, 1 July 2017
Best explanation of JOIN
(INNER) JOIN: Select records that have matching values in both tables. LEFT (OUTER) JOIN: Select records from the first (left-most) table with matching right table records. RIGHT (OUTER) JOIN: Select records from the second (right-most) table with matching left table records. FULL (OUTER) JOIN: Selects all records that match either left or right table records.
