-
set difference query
Im working on some practice questions for my oracle class and one is asking me to list all the hotel rooms that are vacant on june 4th 2006. i know i need to get all rooms and then subtract all the rooms booked on that date to return the vacant ones however i am having trouble getting the SQL right. could someone please help me out.
here is my table structrue
Hotel(hotel_no, name, address)
Room(room_no, hotel_no, type, price)
booking(hotel_no, guest_no, room_no, date_from, date_to)
i need to select hotel_no, room_no, date_from, and date_to
again this is prob pretty simple but i just started learning this after switching from access.
thanks
alex
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
|
|