数据库中各表是这样的
Hotel ( hotelNo, hotelName, city)
Room ( roomNo, hotelNo, type, price)
Booking (hotel, guestNo, dateFrom, dateTo, roomNo)
Guest (guestNo, guestName. guestAddress)
问题是:列出Grosvenor Hotel 中所有房间的详细资料,如果房间已经被占用,还应该包括租用该房间的客人的姓名。
谢谢啦
Hotel ( hotelNo, hotelName, city)
Room ( roomNo, hotelNo, type, price)
Booking (hotel, guestNo, dateFrom, dateTo, roomNo)
Guest (guestNo, guestName. guestAddress)
问题是:列出Grosvenor Hotel 中所有房间的详细资料,如果房间已经被占用,还应该包括租用该房间的客人的姓名。
谢谢啦
slect A.*,B.*,C.*,D.*
from room A left join hotel B on A.hotelNo=B.hotelNo left join Booking C on B.hotelNo=C.hotel left join Guest on C.guestNo = D.guestNo