Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Simple SQL Question

Simple SQL Question

From: Vinh Duong <vduong_at_aei.ca>
Date: Fri, 17 Mar 2000 22:41:05 -0500
Message-ID: <38d2fa84_4@news.aei.ca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US