Talk:SQL Syntax Examples

From Free Knowledge Base- The DUCK Project: information for everyone
Revision as of 11:21, 1 July 2017 by Admin (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Best explanation of JOIN

Sql-joins.png 


   (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.
Retrieved from "http://wiki.robotz.com/index.php?title=Talk:SQL_Syntax_Examples&oldid=15442"