Re: SQL command

From: Ken Denny <ken_at_kendenny.com>
Date: Sun, 30 Jun 2002 18:29:01 GMT
Message-ID: <Xns923D9567F3B8Fkendenny_at_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 - 20:29:01 CEST

Original text of this message