>Hi All,
>
>I have a table with item,qty_in and qty_out field, problem is ,
>how to make 1 sql statement that not include item which SUM(qty_in-qty_out) = 0 ?
>
>Please help
> TIA
SELECT Item, SUM(qyt_in) AS Total_in, SUM(qty_out) AS Total_out ;
FROM ItemTable ;
GROUP BY Item
HAVING Total_in <> Total_out