thanks, but isn't your query will only produce one line / record ?
for my case, there might be many record which has the same date. thanks, --- In Axapta-Knowledge-Village@yahoogroups.com, "henrik3.rm" <[EMAIL PROTECTED]> wrote: > > > > Hi, > try this; > > Custtable Custtable; > ; > select firstonly Custtable order by createdDate desc; > > regards, > Henrik Østergård > computercamp DK > > --- In Axapta-Knowledge-Village@yahoogroups.com, "anton_tjiptadi" > <[EMAIL PROTECTED]> wrote: > > > > Hi, > > How to write a subquery in X++ Select statement > > > > for ex in SQL Server : > > -- select * from CustTable where createddate = (select max > > (createddate) from Custtable) > > > > thanks, ------------------------ Yahoo! Groups Sponsor --------------------~--> Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/