Jump to content

SQL/Join

From Wikiversity
< SQL
(Redirected from Join (SQL))

An SQL join clause combines records from two or more tables in a database.


Two tables

[edit | edit source]
tblSuit
Suit Color
tblLight
Light Color



Inner join
SELECT * FROM tblSuit
JOIN tblLight ON tblSuit.Color = tblLight.Color
Suit tblSuit.Color Light tblLight.Color



Three tables

[edit | edit source]
ta
ca
va
yooo
te
ce
ve
yooo
tu
cu
vu
yooo