SQL Join

·        A SQL JOIN combines records from two tables.
·        A JOIN locates related column values in the two tables.

·        A query can contain zero, one, or multiple JOIN operations.
·        INNER JOIN is the same as JOIN; the keyword INNER is optional.
Different types of JOINs
·        (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.
In JOIN’s the INNER and OUTER keywords are optional.