How to get related records from sql table

Question

I have one table in which i have fields like below

ID1	ID1-Details	ID2	ID2-Details
1	ABC	8	GGG
2	HH	3	GGG
3	hhy	1	jjj

Now i want to get data like for ID1=1 and ID2=1 how i make a query to get the details of ID1=1 and ID2=1 as id1=1 is in first row and ID2= 1 is in third row

Midhun T P · Answer

Hi So what is the logic behind selecting id1 as 33 and id2 as 55? If you know what values to be considered for id1 and id2 then you can use Union clause - SELECT id1_cmnts AS all_cmnts FROM tablename WHERE id1=33 UNION SELECT id2_cmnts FROM tablename WHERE id2=55

Mark Tabor · Answer

dear check the drobbox for referene i need this https://www.dropbox.com/s/dxeo38940aguybm/New%20Microsoft%20Excel%20Worksheet.xlsx?dl=0

Midhun T P · Answer

Hi It would have been better if you had provided desired output as a table structure. As per my understanding I have written a query. Please check it - SELECT t1.ID1t1.ID1_Detailst2.ID2t2.ID2_Details FROM tablename t1 FULL OUTER JOIN tablename t2 ON t1.ID1=t2.ID2