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>
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 CarlinReceived on Sun Jun 30 2002 - 20:29:01 CEST