How to get related records from sql table

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 -

0

dear check the drobbox for referene i need this

https://www.dropbox.com/s/dxeo38940aguybm/New%20Microsoft%20Excel%20Worksheet.xlsx?dl=0

0

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.ID1,t1.ID1_Details,t2.ID2,t2.ID2_Details FROM tablename t1 FULL OUTER JOIN tablename t2 ON t1.ID1=t2.ID2

0