I have the following SQL query. My problem is the IIF at the end of the select statement. I get a invalid syntex near the <
SELECT TOP (100) PERCENT dbo.ictran.loctid, dbo.ictran.sono, dbo.ictran.palletno, dbo.ictran.item, SUM(dbo.ictran.tqty) AS tqty, dbo.sotran.descrip, dbo.sotran.custno,
dbo.arspec.catalog AS custitem, dbo.icitem.plinid, SUM(dbo.icitem.weight * dbo.ictran.tqty) AS pweight, dbo.icitem.weight, dbo.sotran.unitsper,
SUM(dbo.ictran.tqty / dbo.sotran.unitsper) AS cartons, dbo.sotran.salesmn, dbo.icitem.upccode, dbo.icitem.eancode, dbo.icitem.barcode, dbo.icitem.barcodei,
dbo.icitem.stkumid, dbo.icitem.unitsper AS mcarton, dbo.icitem.unitsperi AS incarton, SUM(IIF(dbo.ictran.tqty < dbo.sotran.unitsper,dbo.icitem.stkumid, dbo.icitem.unitsperi,0))
FROM dbo.ictran INNER JOIN
dbo.sotran ON dbo.ictran.sono = dbo.sotran.sono AND dbo.ictran.item = dbo.sotran.item INNER JOIN
dbo.arspec ON dbo.sotran.custno = dbo.arspec.custno AND dbo.sotran.item = dbo.arspec.item INNER JOIN
dbo.icitem ON dbo.ictran.item = dbo.icitem.item
WHERE (dbo.ictran.sono <> ' ') AND (dbo.ictran.rfdone = 0)
GROUP BY dbo.ictran.sono, dbo.ictran.loctid, dbo.ictran.palletno, dbo.ictran.item, dbo.sotran.descrip, dbo.sotran.custno, dbo.arspec.catalog, dbo.icitem.plinid,
dbo.sotran.unitsper, dbo.sotran.salesmn, dbo.icitem.upccode, dbo.icitem.barcode, dbo.icitem.barcodei, dbo.icitem.eancode, dbo.icitem.stkumid, dbo.icitem.weight,
dbo.icitem.unitsper, dbo.icitem.unitsperi
ORDER BY dbo.ictran.sono, dbo.ictran.palletno, dbo.ictran.item
