SQL/Join

< SQL
(Redirected from Join (SQL))

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


Two tables edit

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

ta
ca
va
yooo
te
ce
ve
yooo
tu
cu
vu
yooo