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