>>... >> 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".