第1个回答 2008-08-20
select *
from 酒店表,酒店房间价格表
where 酒店房间价格表.id in
(select 酒店表.id
from 酒店表
where HotelCity='城市名')
select min(HousePrice) ,max(HousePrice)
from 酒店房间价格表
where HotelName ='酒店名'
select min(HousePrice)
from 价格表
where id in
(select 酒店表.id
from 酒店表
where HotelCity='城市名')
第2个回答 2008-08-20
select * from hotel where city='大连'
select max(a),min(b) from (select max(price)as a,min(price) as b where hotelname in (select hetelname from hotel where city='大连'))