I Want to Query a table with two parameters in where condition and both the parameters are returned from another query : I Want to Query a table with two parameters in where condition and both the parameters are returned from another query.

Let us say a table t1 with column1 and column2,  if I use a query select column1,column2 from t1,suppose it return 10 records

 I want to query something like below
for(int j=0;j<10;j++)
{
select * from t2 where t2.column1=t1.column1(jth position) and t2.column2=t1.column2(jth position)
}