BAQ - Left Outer Join

Epicor ERP 10
1

Hello,

As someone new to BAQ, could someone tell me the best way to do a left outer join in this tool?

Thanks
Pete

2

Make a link between the two tables to join. Select that link, and then in the relationship pane below, there is a dropdown to specify the JOIN type. The description of the dropdown items varies depending on your version of E10

3

Click on the join, then the drop down at the bottom corner is the same as left/right/outer/inner. Different names, but if you read what it says, it’s not too hard to figure out.

image
image1003×452 25.7 KB

4

With PartTran having a higher sequence in the table order than POHeader:

image
image694×171 14.3 KB

5

excellent - Thank you!

6

screenshot helped - Thanks