SQL | SELECT data from Multiple Tables

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 :



ID FirstName
1 Nisha
2 Manoj
3 Pooja

Geeks2 table :

ID LastName
1 Gupta
2 Desai
3 Kumari

Geeks3 table :

GID PID Asset
1 P1 Laptop
2 P2 Desktop
3 P3 Laptop
4 P4 None

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 :

GID PID Asset FirstName LastName
1 P1 Laptop Nisha Gupta
2 P2 Desktop Manoj Desai
3 P3 Laptop Pooja Kumari
4 P4 None NULL NULL

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

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.