Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT HHotel.HOTELNAME, HHotel.CITY
- FROM HHotel
- INNER JOIN HRoomClassInHotel
- ON HHotel.HOTELID = HRoomClassInHotel.HOTELID
- INNER JOIN HRoomType
- ON HRoomClassInHotel.ROOMTYPEID = HRoomType.TYPEID
- WHERE HOTELNAME != 'Kamari, Turku'
- ORDER BY CITY
Add Comment
Please, Sign In to add comment