ÇóÈý±íÁªºÏ²éѯSQL - MS-SQL Server / Ó¦ÓÃʵÀý

²é ¾Æµê ·¿ÐÍ ¼Û¸ñ ¹Øϵ
  ¾Æµê--->·¿ÐÍ 1£ºn
  ·¿ÐÍ--->¼Û¸ñ(¼Û¸ñÿÌì¶ÔÓ¦Ò»¸ö¼Û¸ñ£¬ÓпÉÄܶÔÓ¦µÄ¼Û¸ñδÌí¼ÓÊý¾Ý) 1£ºn

SQL code:
select Hotel.[id] as Hotel_id,Hotel.H_name,Hotel.Stars,Hotel_rooms.[id],Hotel_rooms.Room_name,
Rooms_price.Room_id,Rooms_price.Room_price,Rooms_price.Room_Time,
Rooms_price.Room_remain,Rooms_price.Room_food
from Hotel,Hotel_rooms,Rooms_price
where Hotel.H_lineId =1 and Rooms_price.Room_Time='2010-5-8' and Hotel_rooms.[id] =Rooms_price.Room_id


  ÏÖÔÚÓÐÖظ´ Ò²¾ÍÊDzé³öµÄ½á¹ûÓëÓÐÖظ´£¬Ò²¾ÍÊÇ˵ıı¾ÆµêûÓеķ¿ÐÍÓÉÖظ´µÄÊý¾ÝÌî³äÁË¡£

---

ʲô×Ö¶ÎÖظ´ÁË°¡?

---

×îºÃÄÜÉϵã²âÊÔÊý¾Ý£¬°ï¶¥ÏÈ

---

ÒýÓÃ

×îºÃÄÜÉϵã²âÊÔÊý¾Ý£¬°ï¶¥ÏÈ

...........

---

µÚÒ»ÌõÊý¾ÝÓ¦¸ÃÊÇÖظ´µÄ£¬Ò²¾ÍÊÇ˵¸Ã¾ÆµêûÓжÔÓ¦µÄÊý¾Ý£¬±»µÚ¶þÌõµÄÌî³äÁË¡£

---

---

¸Õ²ÅͼƬ·¢´íÁË ÏÖÔÚÉÏÀ´ÁË

---

hotelÓëhotel_rooms±íµÄ¹Øϵ¼ÓÉϾͿÉÒÔÁË

---

SQL code:

select Hotel.[id] as Hotel_id,Hotel.H_name,Hotel.Stars,Hotel_rooms.[id],Hotel_rooms.Room_name,
Rooms_price.Room_id,Rooms_price.Room_price,Rooms_price.Room_Time,
Rooms_price.Room_remain,Rooms_price.Room_food from Hotel,Hotel_rooms,Rooms_price
where Hotel.H_lineId =