Re: SQL command

From: ImPrecise <f_puhan_at_precise.com>
Date: Sun, 30 Jun 2002 17:15:40 -0400
Message-ID: <f_puhan-0BF9E4.17153930062002@vienna7.his.com>

In article <c0f10b81.0206301027.4a1b0f9d_at_posting.google.com>, chico8574_at_hotmail.com (Ric) wrote:

> 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?

I'm not sure I understand the spec completely, but simplistically, wouldn't this work:

SELECT
  part, supplier, city
FROM
  supplies
ORDER BY
  city
/

-- 
The underscore character does not belong in my address. You know the drill...
***
Anyone sufficiently smart enough to configure and use USEnet for research should
be smart enough to Read The Freakin' Documentation!

Received on Sun Jun 30 2002 - 16:15:40 CDT