Hi,

   i'm new to apex. I need help in writing nested Query in soql.

I need the following nested query in SOQL form. IS it possible write in this way?Then how to write it in SOQL.

please help me

the query is written in sql form:

select emailid from userprofile where empname in (select deptHead from department where deptId in (select deptId from Userprofile where empId='1001'));

-Shravan