I having trouble with this query
it is executing quit well but I cannot make out
how is this select statement working.
Any help or explaination on this problem will be appereciated ..
select * from emp where eid IN (select eid from works where cid=(select cid from company where city=emp.city))