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