Talk:SQL Syntax Examples

From Free Knowledge Base- The DUCK Project: information for everyone
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"