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 like 'hotel%'?
and a.hot_aera<>'1000'?
and a.hot_number=b.room_hotelnumber?
and ?b.room_type='0'?
and b.room_tuijian='1'
這條查詢語句怎么優化??？？？？
慕尼黑8549860
2018-12-07 05:12:58
