please help i am beginner in Axapta to make it short i am trying to apply this SQL code
SET SALESQTY = FORECASTSALES.SALESQTY - PURCHREQLINE.PURCHQTY
FROM FORECASTSALES INNER JOIN
PURCHREQLINE ON FORECASTSALES.PROJID = PURCHREQLINE.PROJECT AND FORECASTSALES.ACTIVITYCODE = PURCHREQLINE.ACTIVITYCODE AND
FORECASTSALES.ITEMID = PURCHREQLINE.ITEMID
how could be code in x++ i am trying to put this in method
Many thanks and best regards.