~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/join.rst

  • Committer: Mark Atwood
  • Date: 2011-12-11 22:56:39 UTC
  • mfrom: (2465.1.1 drizzle)
  • Revision ID: me@mark.atwood.name-20111211225639-3d8ype7g2y82dci5
mergeĀ lp:~brianaker/drizzle/libdrizzle-breakout

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
Join
 
1
JOIN
2
2
====
3
3
 
4
4
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``.
61
63
 
62
64
 
63
65
How joins are executed