第一種 select top 20 ?* from (select a.hot_level, a.hot_name,b.room_name,b.room_priceq,b.room_pricep,b.room_pricez,b.room_type,b.room_tuijian,b.id,a.hot_number,a.id as hotelid,a.hot_time,a.hot_pic from LI_hotel a,LI_room b where a.hot_number=b.room_hotelnumber) as a where ?hot_number like 'hotel%' and room_tuijian='1' and room_type='0' 第二種 select top 20 a.hot_level, a.hot_name,b.room_name,b.room_priceq,b.room_pricep,b.room_pricez,b.room_type,b.room_tuijian,b.id,a.hot_number,a.id as hotelid,a.hot_time,a.hot_level,a.hot_pic from LI_hotel a,LI_room b where ?a.hot_number=b.room_hotelnumber and hot_number like 'hotel%'?and b.room_tuijian='1' and b.room_type='0'