1. SELECT price,type
FROM Room
INNER JOIN Hotel
ON Hotel.hotelNo=room.hotelNo
WHERE hotelName=’Grosvenor Hotel’
其中WHERE hotelName是Hotel表中的,
1. SELECT price,type
FROM Room
INNER JOIN Hotel
ON Hotel.hotelNo=room.hotelNo
WHERE hotelName=’Grosvenor Hotel’
其中WHERE hotelName是Hotel表中的,