Difference between revisions of "SQL Join"
From Wiki @ Karl Jones dot com
Karl Jones (Talk | contribs) (Created page with "In SQL, the keyword '''join''' (often '''JOIN''') indicates the combining of records from two tables. == See also == * SQL * SQL statement examples == External...") |
Karl Jones (Talk | contribs) |
||
| Line 1: | Line 1: | ||
In [[SQL]], the keyword '''join''' (often '''JOIN''') indicates the combining of records from two tables. | In [[SQL]], the keyword '''join''' (often '''JOIN''') indicates the combining of records from two tables. | ||
| + | |||
| + | == Syntax == | ||
| + | |||
| + | The general syntax is: | ||
| + | |||
| + | <nowiki>SELECT column-names | ||
| + | FROM table-name1 JOIN table-name2 | ||
| + | ON column-name1 = column-name2 | ||
| + | WHERE condition</nowiki> | ||
== See also == | == See also == | ||
Latest revision as of 08:10, 16 May 2016
In SQL, the keyword join (often JOIN) indicates the combining of records from two tables.
Syntax
The general syntax is:
SELECT column-names FROM table-name1 JOIN table-name2 ON column-name1 = column-name2 WHERE condition
See also
External links
- SQL Join @ DoFactory
