Adding ship to state to BAQ

[Nancy_Hoyt]

Hi Tanya,

Make it a select distinct via this:

BAQ - Select Distinct

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]

Nancy