-
Oracle9i
hi guys,
first of all i would like to thank SKHANAL and all other members of this forum for helping me.
here is the question in my assignment:
List the most expensive book purchased by customer 1017?
i have these tables: books, customers, orders, orderitems.
my answer was:
SELECT MAX(retail) " Most Expensive Book"
FROM orders NATURAL JOIN orderitems NATURAL JOIN books
where customer#=1017
;
I get the right answer but i can't get both the book title and its price at the same time on the output. i only get this :
Most Expensive Book
--------------------
89.95
So, is there any other way to write the SQL code and get something like this:
Title
------------------------
Handcranked Computeres
Most Expensive Book
-------------------
89.95
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|