Re: Simple SQL Question

From: Marcello Lima <marcello.lima_at_predialnet.com.br>
Date: 2000/03/19
Message-ID: <023b36f2.1b5f9c09@usw-ex0108-061.remarq.com>#1/1

--First Question:

SELECT cname
FROM company c
WHERE city IN (SELECT city

              FROM company
              WHERE cname = 'Bank of Trade');

--Second question:

SELECT city
FROM company c
WHERE bid IN (SELECT bid

              FROM works
              WHERE eid IN (SELECT eid
                            FROM manages ma, employee e
                            WHERE ma.eid = e.eid
                            AND e.city = c.city);

I hope that the queries helps you!!!

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Received on Sun Mar 19 2000 - 00:00:00 CST