RE: [development-axapta] Query Question

[Janet Blake]

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: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Chwaszczewski,
Jim
Sent: Thursday, August 21, 2008 9:54 AM
To: development-axapta@yahoogroups.com
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]