anton_tjiptadi
how about this code:
custtable _table1,_table2;
date _date;
select max(createddate) from _table1;
_date = _table.createdate ;
select _table2 where _table2.createdate == _date;
======= 2005-01-25 10:30:06 您在来信中写道：=======
>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 ?terg?d
>> 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
>
>
>
>
= = = = = = = = = = = = = = = = = = = =
致
礼！
akin
[EMAIL PROTECTED]
2005-01-25
------------------------ 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/
