I would use a notexists join:
static void Job1(Args _args)
{
InventTable a;
InventTableModule b;
;
select ItemId,ItemName
from a
notexists join b
where b.itemid == a.itemid
&& b.blocked == noYes::No;
}
________________________________
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Chwaszczewski,
Jim
Sent: Thursday, August 21, 2008 9:54 AM
To: [email protected]
Subject: [development-axapta] Query Question
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] <mailto:JChwaszczewski%40wipfli.com>
[Non-text portions of this message have been removed]
