SQL Statements – JOIN

INNER JOIN

• Return common records from 2 tables

LEFT JOIN

• Return all records from LEFT table
• Return matching records from RIGHT table

CROSS JOIN

OUTER JOIN

• This is an optional keyword

  [sql]A LEFT JOIN B = A LEFT OUTER JOIN B
  A RIGHT JOIN B = A RIGHT OUTER JOIN B
  A FULL JOIN B = A FULL OUTER JOIN B
  A INNER JOIN B = A JOIN B[/sql]