The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables.
57
57
58
58
59
59
.. note::
60
Implicit cartesian products of the form ``SELECT * FROM t1, t2`` without a ``WHERE`` or ``ON`` condition will error. If such behavior is intended please use ``SELECT * FROM t1 CROSS JOIN t2``.
60
Implicit cartesian products of the form ``SELECT * FROM t1, t2``
61
without a ``WHERE`` or ``ON`` condition will error. If such
62
behavior is intended please use ``SELECT * FROM t1 CROSS JOIN t2``.