Query to achieve some kind of Left/Right Join with a extra condition

andrey63

Hello,

I have 2 tables like in the below image and need a Query in Nav that produces the result you see in the image as "Desired". This is needed in order to indentify the rows with NULL values and present them in a report:


My tables can have thousands of rows, so this is why I want to find a way to indentify this in an efficient way, without looping throw each row..

Do you know if something like this can be achieved with a NAV query or in another way?

Thanks