Subqueries and full outer joins

Kinetic ERP
,
1

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):
image
image

InvcDtl 1st (misses OrderRels without invoices):
image
image

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…

2

That’s Left order.

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

3

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