BAQ two table results

Epicor ERP 10
10

I get exactly what I want in SQL:

image
image.png1172×582 32.7 KB

But in the BAQ the Where is thrown on the Join???

image