Re: SQL command

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