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 --------------------~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/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/