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
, 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