Nesting Query Problem

hello,

i am having a MySQL query with 3 levels of Nesting in it. it looks like this..

select ID1 from table1,
( select ID2 from table2,
(select ID3 from table3 where SOMECONDITION) as res1
WHERE ID2 = res1.ID3 ) as res2
WHERE ID1=res2.ID2 AND ID1=res1.ID3

Here the problem i am getting is i am not able to check this condition [ ID1=res1.ID3 ] the ID3 value is only visible to res1 SCOPE , DO u have a ny idea ???

thanks for reading patiently

-gaurav

Also in #PHP _↴