Talk:SQL Syntax Examples: Difference between revisions
Jump to navigation
Jump to search
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 09: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.