How do I write this SQL query in X++?
select a.ItemId,a.ItemName, b.blocked from InventTable a join (select ItemId,max(blocked) as blocked from InventTableModule group by ItemId) b on b.ItemId=a.ItemId I'm trying to filter a query so that only items that are not blocked are selected. Jim Chwaszczewski Wipfli, LLP Email: [EMAIL PROTECTED] [Non-text portions of this message have been removed]
