How do I convert following sql into x++?
/*INNER JOIN PURCHTABLE ON PURCHLINE.PURCHID = PURCHTABLE.PURCHID
and PURCHLINE.DATAAREAID = PURCHTABLE.DATAAREAID
and PURCHLINE.PARTITION = PURCHTABLE.PARTITION
LEFT JOIN INVENTDIM ON PURCHLINE.INVENTDIMID = INVENTDIM.INVENTDIMID
and PURCHLINE.PARTITION = INVENTDIM.PARTITION
LEFT JOIN ECORESCATEGORY on PURCHLINE.PROCUREMENTCATEGORY = ECORESCATEGORY.RECID
and PURCHLINE.PARTITION = ECORESCATEGORY.PARTITION
AND PURCHLINE.ITEMID = ''*/
　
while select itemid, purchId from purchLine
join inventDimId from inventdim
where inventDim.inventdimid == purchLine.inventDimId
join Recid from ecoResCategory
where ecoResCategory.RecId == purchLine.ProcurementCategory
join purchId from purchLine
where purchLine.purchId == PurchTable.purchId
//&& purchLine.itemid != ""
//&& inventDim.ItemId == itemId*/
