Viewing post 46 (of 46 total)
It might be fun to try out the HAVING clause...
INNER JOIN InventTrans G
on (a.itemid = g.itemid)
GROUP BY <selected columns>
HAVING MAX(G.DateExpected) > GETDATE() - 90
Just be aware...
August 20, 2010 at 1:17 pm
#1209890