Cross Join:     A full cartesian product.   Same as doing  SELECT * FROM a,b

Inner Join:     The most common kind of join.  Same as doing   SELECT * FROM a,b WHERE a.id = b.id;

Outer Join:     Lists ALL rows from one table, PLUS any rows that match from the other table.
                            (eg. has NULLs on the second table, as needed)