SQL command/I'm stuck
From: Ric <chico8574_at_hotmail.com>
Date: 29 Jun 2002 20:32:35 -0700
Message-ID: <c0f10b81.0206291932.46a7e7c2_at_posting.google.com>
Date: 29 Jun 2002 20:32:35 -0700
Message-ID: <c0f10b81.0206291932.46a7e7c2_at_posting.google.com>
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.