I'm trying to create a new query so that my user can have a list of new prep lists on their landing page.  using table STOPRELIS, I was able to create a query but there is a line per product, when I only want the prep list, pick ticket, and so number.  Can you do a select distinct in the Query tool ?  And if so, how?

thank you!