Subqueries and full outer joins

I’m seeing that in the BAQ designer, if doing Full outer joins on a subquery, it doesn’t work. It only does a Left join. Simplified example…

OrderRel 1st (missing an invoice detail):

InvcDtl 1st (misses OrderRels without invoices):

It isn’t a Epicor/BAQ designer issue as this is how SSMS runs the queries as well.

I’d like to understand this more. Any SQL gurus here that can point me to documentation on this? I’m not finding anything on Google…

That’s Left order.

…Sorry, I don’t have anything useful to say, but I am curious.

I figured it out. Need to remove the table criteria, have criteria on the subquery criteria where clause, using ORs for either table.

1 Like