Re: SQL command/I'm stuck
From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 01 Jul 2002 15:44:17 GMT
Message-ID: <3D2078AF.7E542952_at_exesolutions.com>
Date: Mon, 01 Jul 2002 15:44:17 GMT
Message-ID: <3D2078AF.7E542952_at_exesolutions.com>
Ric wrote:
> I'm using SQL 8.0.
>
> I have translated the English sentence of "Get supplier numbers and
> status for suppliers in Paris" to the SQL command:
>
> select s#, status from supplier where upper(city) = 'PARIS';
>
> I don't know what to type for "Get color and city for "non Paris"
> parts with weight greater than 10 (hint: <> is the operator for not)"
>
> Any help would be appreciated.
A bit of help for those trying to help you is in order.
- What is the actual version of Oracle you are using (it is not 8.0).
- What is the structure of the tables.
Daniel Morgan Received on Mon Jul 01 2002 - 17:44:17 CEST