Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Simple SQL Question
Hi,
I have the following tables:
Employee (eid, ename, street, city)
Works (eid, bid, cname,salary)
Company (bid, cname,city)
Manages (eid, mid, bid, cname)
A company, which is uniquely identified by its cname, may have branches (indicated by bid) in more than one city.
Help me the write TWO appropriate queries that each satisfy the following requirements:
1- Find the names of companies that are located IN EVERY CITY in which 'Bank of Trade' is located.
2-Make a list of the cities which have one of its residents as a manger IN EVERY COMPANY located in the city.
Gracias,
Vinh
Montreal
Received on Fri Mar 17 2000 - 21:41:05 CST