Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select hroom.roomnumber from hroom,hguest,hbooking
- where
- '28.01.2012' not between to_char(arrivaldate, 'dd.mm.yyyy') and to_char(departuredate, 'dd.mm.yyyy') and
- hguest.bookingid = hbooking.bookingid and
- hroom.roomnumber = hguest.roomnumber
Add Comment
Please, Sign In to add comment