改个SQL语句

Question

SELECT   dbo.Area.AreaName, dbo.ShopList.*
FROM         dbo.Area INNER JOIN
                      dbo.ShopDeliveryArea ON dbo.Area.ID = dbo.ShopDeliveryArea.AreaID INNER JOIN
                      dbo.ShopList ON dbo.ShopDeliveryArea.ShopID = dbo.ShopList.ID
统计结果的记录数

Answer 1

你想改成什么样？ 改成下面这样行不行？select * from  dbo.Area问题说明越详细，回答也会越准确！参见如何提问。（提问的智慧）

Answer 2

SELECT   COUNT(1)
FROM         dbo.Area INNER JOIN
                      dbo.ShopDeliveryArea ON dbo.Area.ID = dbo.ShopDeliveryArea.AreaID INNER JOIN
                      dbo.ShopList ON dbo.ShopDeliveryArea.ShopID = dbo.ShopList.ID

Answer 3

SELECT count(1)
FROM Area A 
   INNER JOIN ShopDeliveryArea  S 
   ON A.ID = S.AreaID 
   INNER JOIN ShopList SL
   ON S.ShopID = SL.ID