Hi all,
I am trying to convert the following SQL into an X++ Query. All help very much appreciated:
SELECT
CUSTINVOICEJOUR.INVOICEACCOUNT,CUSTINVOICETRANS.NAME,COUNT(CUSTINVOICETRANS.itemid) as ItemCount
FROM
CUSTINVOICEJOUR
inner
join CUSTINVOICETRANS on CUSTINVOICEJOUR.SALESID =CUSTINVOICETRANS.SALESID
WHERE
CUSTINVOICEJOUR.INVOICEDATE between ‘20110101’ and ‘20110131’
GROUP
BY CUSTINVOICEJOUR.INVOICEACCOUNT,CUSTINVOICETRANS.NAME
HAVING
COUNT(CUSTINVOICETRANS.itemid) > 10
Many thanks once again people. This is my first ever post; hoping this site proves a useful tool.
Rafiq