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 where
cl.parentrecid=a.parentrecid)
the purpose is I want to get a payment line which the due date is
maxmimum, if I dont use the subquer -> select max...., what I got is
a number of lines with many duedate. I already run this query in SQL
analyzer and worked.
.. or maybe in axapta there's another approach.. ?
many thansk in advance.
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.