Join

Inner Join/Self Join

SELECT <table>.<column> <name>, <table>.<column> <name>, ...
    FROM <table> <name>
        INNER JOIN  <table> <name>
        ON <table>.<column> = <table>.<column>;              -- inner join / self join

Left Outer Join

SELECT <table>.<column> <name>, <table>.<column> <name>, ...
    FROM <table> <name>
        LEFT OUTER JOIN  <table> <name>
        ON <table>.<column> = <table>.<column>;              -- left outer join

Right Outer Join

SELECT <table>.<column> <name>, <table>.<column> <name>, ...
    FROM <table> <name>
        RIGHT OUTER JOIN  <table> <name>
        ON <table>.<column> = <table>.<column>;              -- right outer join

Full Outer Join

SELECT <table>.<column> <name>, <table>.<column> <name>, ...
    FROM <table> <name>
        LEFT OUTER JOIN  <table> <name>
        ON <table>.<column> = <table>.<column>
UNION
SELECT <table>.<column> <name>, <table>.<column> <name>, ...
    FROM <table> <name>
        RIGHT OUTER JOIN  <table> <name>
        ON <table>.<column> = <table>.<column>;              -- full outer join

Cross Join

SELECT <table>.<column> <name>, <table>.<column> <name>, ...
    FROM <table> <name>
        CROSS JOIN JOIN  <table> <name>                      -- cross join