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

My Personal Notes arrow_drop_up

Save