BAQ - Select Distinct

Epicor ERP 10
1

Any ideas how I can return distinct records? I am basically joining the Part to the VendPart table, but it’s returning duplicate entries.

Here’s my BAQ with a Left outer join from Part to VendPart based off “Company” and “PartNum”.
image

This is my return. It’s basically the same, but I cannot have it do a select distinct.
image

As you can see I only have one part linked to this supplier. Only thing I noticed when I queried just the “VendPart” table is that the effective date changed from 10/2 to 10/3, creating 2 records.

image
image.png1105×303 15 KB

Without having to write a view and use external BAQ, any ways I can get “Select Distinct” in my query?

1 Like
2

You can see the solution to your problem here: BAQ - Get records where one field is unique - ERP 10 - Epicor User Help Forum

3

Or if you are just trying to use the distinct operator as you would in SQL, go to Query Builder, SubQuery Options, Result Set Rows. Change All to Distinct.image

7 Likes
4

Ah thank you. Was looking all over for that distinct option. That works.

5

I am trying to do the same but in E9 where they don’t have sub-queries. Is it possible?

1 Like