AddRange

[Bars]

ну например

Select inventtable.itemid from inventtable
where itemid not in
(SELECT inventtable.itemid FROM inventtable
inner join inventsum
on inventtable.itemid = inventsum.itemid
where InventSum.Inventdimid = ' АН00000031' AND
InventSum.PostedQty + InventSum.Received - InventSum.Deducted + InventSum.Registered - InventSum.Picked - InventSum.ReservPhysical > 0 )

такиъх условия надо чтобы 2 было...