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?