[Axapta-Knowledge-Village] SubQuery in Axapta

Hi guys, did anyone knows how to use subquery in X++ development? for example, I have a query like this (in ANSI SQL) : select * from custpaymschedline a, custpaymsched b where a.parentrecid=b.recid and b.extrecid=-1999372754 and a.duedate= (select max(duedate) from custpaymschedline cl

[Axapta-Knowledge-Village] Subquery

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 ~-- In low income neighborhoods, 84% do not own