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 -> Re: SQL command

Re: SQL command

From: Ken Denny <ken_at_kendenny.com>
Date: Sun, 30 Jun 2002 18:29:01 GMT
Message-ID: <Xns923D9567F3B8Fkendenny@65.82.44.7>


chico8574_at_hotmail.com (Ric) wrote in
news:c0f10b81.0206301027.4a1b0f9d_at_posting.google.com:

> I don't know how to translate this to SQL 8.0 command.
>
> Get all combinations of supplier and part information such that the
> supplier and part in question are located in the same city.
>
> select part and supplier where city = same???
> Something like that?

Assuming that there is a part table and a supplier table:

Select part.*, supplier.* from part, supplier

   where part.city = supplier.city;

-- 
Ken Denny
http://www.kendenny.com/

"People who drive slower than me are morons, and people who drive faster 
than me are maniacs" - George Carlin
Received on Sun Jun 30 2002 - 13:29:01 CDT

Original text of this message

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