Member Avatar for dendenny01

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 ..
thank you

select * from emp
where eid 
IN (select eid from works 
     where cid=(select cid from company 
                where city=emp.city))
  • 2 Contributors
  • 1 Reply
  • 172 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for rch1231

The query first selects the CID (or city id from what I see) using the employee city shown on the page or in the query.

Then is selects the eid (employee ID's) for all employees whos cid in the works table is equal to the CID pulled from the company data.

It then selects all fields from the employee table whos city is equal to the CID.

Hope that helps

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.