[Dan Cantley]

I have a query I am converting from SQL to an AX AOT query.

It has:
 

LEFT OUTER JOIN INVENTDIMCOMBINATION IDC
.
.
LEFT OUTER JOIN INVENTITEMGTIN UPC
            ON (UPC.INVENTDIMID = IDC.INVENTDIMID OR IDC.INVENTDIMID IS NULL)

I know how to do the UPC.INVENTDIMID = IDC.INVENTDIMID section in the Relations for the outer join, but how do I handle the 

OR IDC.INVENTDIMID IS NULL   

Probably easy to do, but I am not figuring out how to handle this.

Thanks

——————————
Dan Cantley
Systems Analyst
Bedrock Manufacturing Co, LLC
Detroit MI
——————————

[Dan Cantley]

Ah – I need to do a UNION between the two kinds of data I pull up.  On one side of the union, I use ON (UPC.INVENTDIMID = IDC.INVENTDIMID) and have a range where IDC.INVENTDIMID  is not ”  -and on the other side I don’t have a ON (UPC.INVENTDIMID = IDC.INVENTDIMID) and have a range where IDC.INVENTDIMID is ”

It works in SQL – not to try it in AOT.

——————————
Dan Cantley
Systems Analyst
Bedrock Manufacturing Co, LLC
Detroit MI
——————————
——————————————-