x++ syntax

Hi,

I have a good knowledge in SQL query but facing problems when I am trying to write same type of query in ax.

How can I learn those syntax? plz help me.

Hi,

I think the following link will help you: http://msdn.microsoft.com/en-us/library/dd261457.aspx

hope it helps

regards,

Thomas

Hi,

I want the syntax on following topics which are found in SQL "joining, group by, in , not in , sub query etc. " in ax.

Read the AX Development packs you can get these off your partner or MSDN.

hi,

plz let me know how to solve the following problem :

1.If there are two or more tables and sum on a particular field is required with proper grouping.

2.How to excute IN / Not IN in x++ ?

3.How to write subquery like SQL server 2008 in x++.