>Are you sure? I know that such queries can surprise me, but I cannot see what can go wrong here.
>If you look at the output do you see repeats of the invoice table or inventory table?
The base EXISTS syntax gives 537 records. The EXISTS syntax you suggested gives 697 records.
>I wonder whether the problem is in the description of what you are expecting.
After verification, another condition was required in one of the two LEFT JOIN. So, yes, your syntax works.
Thanks