SELECT a.SupplierId, b.CustomerId,c.ComFlag
FROM BillProperty a
JOIN BillHdr b ON a.SupplierId = b.SupplierId
JOIN(
SELECT CustomerId, SUM(CASE WHEN CommFlg = 1 THEN 1 ELSE 0 END) AS ComFlag
FROM BillChg
GROUP BY CustomerId
)c
ON b.CustomerId = c.CustomerId
WHERE a.SupplierId = 745079813 AND c.CustomerId = 2277565
ORDER BY a.SupplierId
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
3 tables and a sum()
Posted - 08/20/2012 : 16:41:28
