[WD25] Query Problem Based on 2 Files

Hi All,

I have 2 different file as below ;

1) ItemUOM
2) ItemAutoDisplay

For the Query i combine both files and set the Join > Included ItemUOM that have no ItemAutoDisplay

But why the ItemUOM record not display in table?
It is mandatory to add relation record to ItemAutoDisplay to view the ItemUOM record.

I just want ItemAutoDisplay file is an option to be add to the record. It is not compulsory.
So the ItemUOM should be listed on the table without ItemAutoDisplay file.

Is it bugs on Query or standard operation?

Thanks.

Regards
Mujahid