... LEFT JOIN StandsIn si ON si.cust = cs.custno ; LEFT JOIN Stands_Out so ON so.cust = cs.custno ; ...>Hi Sergey,
>SELECT ; > Cust, Customer, QtyIn, QtyOut, QtyIn-QtyOut As QtyDiff ; > FROM ( ; > SELECT ; > CustNo As Cust, ; > Customer, ; > SUM(si.StandsIn) AS QtyIn, ; > SUM(so.SerialCnt) As QtyOut ; > FROM Customer cs ; > LEFT JOIN StandsIn si ON si.cust = cs.cust ; > LEFT JOIN Stands_Out so ON so.cust = cs.cust ; > GROUP BY ; > Cust, ; > Customer ; > ) dt1; >*WHERE QtyOut > QtyIn ; >>"CustNo" is the name of the Customer ID in the Customer table; elsewhere it is "Cust".