Skip to content
Related Articles

Related Articles

Improve Article
SQL | SELECT data from Multiple Tables
  • Last Updated : 17 Aug, 2020

Below statement could be used to get data from multiple tables, so, we need to use join to get data from multiple tables.

Syntax :

SELECT tablenmae1.colunmname, tablename2.columnnmae    
FROM tablenmae1  
JOIN tablename2  
ON tablenmae1.colunmnam = tablename2.columnnmae
ORDER BY columnname;  

Let us take three tables, two tables of customers named Geeks1, Geeks2 and Geeks3.

Geeks1 table :



IDFirstName
1Nisha
2Manoj
3Pooja

Geeks2 table :

IDLastName
1Gupta
2Desai
3Kumari

Geeks3 table :

GIDPIDAsset
1P1Laptop
2P2Desktop
3P3Laptop
4P4None

Example to select from multiple tables :

SELECT Geeks3.GID, Geeks3.PID, 
       Geeks3.Asset, Geeks1.FirstName, 
       Geeks2.LastName  
FROM Geeks3
LEFT JOIN Geeks1 
ON Geeks3.GID = Geeks1.ID
LEFT JOIN Geeks2 
ON Geeks3.GID = Geeks2.ID  

Output :

GIDPIDAssetFirstNameLastName
1P1LaptopNishaGupta
2P2DesktopManojDesai
3P3LaptopPoojaKumari
4P4NoneNULLNULL

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

 

My Personal Notes arrow_drop_up
Recommended Articles
Page :