JOIN

Join

An SQL join clause combines records from two or more tables in a database. It creates a set that can be saved as a table or used as it is. A JOIN is a means for combining fields from two tables by using values common to each. ANSI-standard SQL specifies five types of JOIN: INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER and CROSS. As a special case, a table can JOIN to itself in a self-join.

The above text is a snippet from Wikipedia: Join (SQL)
and as such is available under the Creative Commons Attribution/Share-Alike License.

join

Noun

  1. An intersection of piping or wiring; an interconnect.
  2. An intersection of data in two or more database tables.
  3. The lowest upper bound, an operation between pairs of elements in a lattice, denoted by the symbol .

Verb

  1. To combine more than one item into one; to put together.
  2. To come together; to meet.
  3. To come into the company of.
  4. To become a member of.
  5. To produce an intersection of data in two or more database tables.
  6. To unite in marriage.
  7. To enjoin upon; to command.
  8. To accept, or engage in, as a contest.


The above text is a snippet from Wiktionary: join
and as such is available under the Creative Commons Attribution/Share-Alike License.

Need help with a clue?
Try your search in the crossword dictionary!