March 29th, 2004, 10:07 PM
|
|
Contributing User
|
|
Join Date: Mar 2004
Posts: 40
Time spent in forums: 7 h 6 m 35 sec
Reputation Power: 5
|
|
|
need help with a query
Hi everyone! I'm a current student in college and I'm just starting to take SQL. I need help with the query below.
Are any orders charging a Customer an incorrect price for the "Ace Tennis Net"s? List the Customer ID, Name, RepID, OrdID, Product desc, Item Price and StdPrice with "OK" or "Error" depending on whether the item price is the same as the standard price or not.
These queries are taken from the tables in the Oracle SQL database downloaded from Oracle.com
Could anyone help me with that query?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
