SELECT ;
			cs.custno, ;
			cs.customer, ;
			QtyIn, ;
			QtyOut, ;
			QtyIn - QtyOut As QtyDiff ;
		FROM ;
			customer cs ;
...

>I tried the following and I keep getting SYNTAX ERROR. Is there anything about the below SQL Statement that would cause that? I do not readily see any syntax errors. Would removing the NVL functions cause a syntax error?
>
>

>	SELECT ;
>			cs.custno, ;
>			cs.customer, ;
>			QtyIn As 000000, ;
>			QtyOut As 000000, ;
>			QtyIn - QtyOut As QtyDiff ;
>		FROM ;
>			customer cs ;
>		LEFT JOIN ;
>			(;
>			SELECT Cust, SUM(StandsIn) As QtyIn ;
>				FROM StandsIn ;
>				GROUP BY ;
>					si.cust, ;
>					cs.customer ;
>			) ;
>			si ON si.cust = cs.custno ;
>		LEFT JOIN ;
>			(;
>			SELECT Cust, SUM(SerialCnt) As QtyOut ;
>				FROM Stands_Out ;
>				GROUP BY ;
>					so.cust, ;
>					cs.customer ;
>			) ;
>			so ON so.cust = cs.custno ;
>		ORDER BY cs.Customer
>