SQL Interview Question

Type Of JOINS
INNER JOIN-simple join/default
    Returns all rows for which there is at least one match in both table

LEFT JOIN- left outer join
    Return all rows form left table and the match row form right table

RIGIT JOIN-right outer join
    Return all from right table and match row for left table

FULL JOIN
    Return all rows for which there is a match in either of tables. union of left and right join

CROSS JOIN