Good catch, Beth! I only noticed the problem with group by, though here I may be wrong.

>Hi Cecil,
>
>PMFJI, but with the error you get and what I see, the problem may be with your On string. Try,
>

>...
>                 LEFT JOIN StandsIn si ON si.cust = cs.custno ;
>                  LEFT JOIN Stands_Out so ON so.cust = cs.custno ;
>...
>

>>Hi Sergey,
>>
>>I am not very good at these SQL statements as can be seen below:
>>
>>

>>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".
>>
>>I get the following error: "SQL: Column 'Cust' is not found."