I'd suggest to read this:
Visual Representation of SQL Joins[
^]
When there's no common column, the only way to join tables is to use
cross join
, but (!) that join produces lots of records, because produces the Cartesian product of the tables involved in the join.
For further details about cross join, please see:
Using Cross Joins[
^]