Hi,
So I want to do this in the AOT (AX 7):
SELECT IVT.ITEMID, IVBC.ITEMBARCODE
FROM INVENTITEM IVT
LEFT OUTER JOIN INVENTITEMBARCODE IVBC
ON IVT.ITEMID = IVBC.ITEMID
WHERE
IVBC.ITEMID IS NOT NULL
OR IVT.ITEMID = N'1234'
So what I want is to filter out the values in INVENTITEMBARCODE when they don't exist... except in certain cases.
I have read several blogs about Joins and Join types. I'm thinking that there is some way to use Exist Joins to do this but I cannot find any good examples.
Thanks in Advance.
*This post is locked for comments
I have the same question (0)