SQL_ 嵌套查询

今天写一个查询语句，需要查询CODE、总数量、发货量、未发货量，需要用嵌套查询 在此记录下语法SQL功底有待提升

--查询  嵌套
select T.Code,T.DeliveryCount,T.TotleCount,T.TotleCount-T.DeliveryCount as NoDelivery from(

SELECT   dbo.[Order].Code, COUNT(dbo.Courier.CourierCode1) AS DeliveryCount, COUNT(dbo.Courier.CourierID) 
                AS TotleCount
FROM      dbo.Courier INNER JOIN
                dbo.OrderSub ON dbo.Courier.OrderSubID = dbo.OrderSub.OrderSubID INNER JOIN
                dbo.[Order] ON dbo.OrderSub.OrderID = dbo.[Order].OrderID
WHERE   (dbo.[Order].ReceiverTEL = ' 电话' AND (dbo.[Order].IsRefund = 0) OR
                (dbo.[Order].IsRefund = 0) AND (dbo.[Order].BuyerPhone = '电话')
GROUP BY dbo.[Order].Code
)
as T

---

select T.Code,T.DeliveryCount,T.TotleCount,T.TotleCount-T.DeliveryCount as NoDelivery,T.OrderID ,T.ReceiverProvince,
T.ReceiverCity,T.ReceiverDistrict,T.ReceiverAddress
from(

SELECT   dbo.[Order].Code, COUNT(dbo.Courier.CourierCode1) AS DeliveryCount, COUNT(dbo.Courier.CourierID) 
                AS TotleCount,[Order].OrderID,[Order].ReceiverDistrict,[Order].ReceiverAddress,[Order].ReceiverCity,[Order].ReceiverProvince
				
FROM      dbo.Courier INNER JOIN
                dbo.OrderSub ON dbo.Courier.OrderSubID = dbo.OrderSub.OrderSubID INNER JOIN
                dbo.[Order] ON dbo.OrderSub.OrderID = dbo.[Order].OrderID
WHERE   (dbo.[Order].ReceiverTEL = '电话') AND (dbo.[Order].IsRefund = 0) OR
                (dbo.[Order].IsRefund = 0) AND (dbo.[Order].BuyerPhone = '电话')
GROUP BY dbo.[Order].Code,[Order].OrderID,
[Order].ReceiverAddress,
[Order].ReceiverCity,
[Order].ReceiverDistrict,
[Order].ReceiverProvince
)
as T