Uncommon · Knowledge
Join (SQL)
SQL clause
A join clause in the Structured Query Language (SQL) combines columns from one or more tables into a new table. The operation corresponds to a join operation in relational algebra. Informally, a join stitches two tables and puts on the same row records with matching fields.
From Wikipedia
A join clause in the Structured Query Language (SQL) combines columns from one or more tables into a new table. The operation corresponds to a join operation in relational algebra. Informally, a join stitches two tables and puts on the same row records with matching fields. There are several variants of JOIN: INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER, CROSS, and others.
Text: Wikipédia, CC BY-SA 4.0. · Image: GermanX (CC BY-SA 4.0) ·
Related cards
-
I★
Insert (SQL)
SQL statement
-
★
Join (graph theory)
Operation that combines two graphs
-
★★
Union (set theory)
Operation denoted by symbol “∪” applied on two sets; the set of all distinct elements in the collection
-
★★★★
Set (mathematics)
Well-defined mathematical collection of distinct objects
-
P★★
PL/SQL
One of the technologies in Oracle Database, a programming language that combines SQL syntax
-
★
Query language
Computer language used to make queries into databases and information systems such as SQL or XQuery