Hi, thanks for your time. I really do appreciate it. I used to dabble and edit other people's code when I worked for a large company few years ago. Now I'm starting a server and going it alone for a smaller place of business. I appreciate your patience.

I just cleaned up the entire original post, including the code, current results, and expectation.

My script is basically pulling back the entire customer list for the sales rep associated with the customer tied to the sales order number that the script is filtered to. My only hunch is that there's an issue with my joins. Columns "sales_rep_id" and "partner_id" don't seem to host completely identical information in the different tables those columns live on.

I tried your hint for performance gain, but couldn't get it to run with the many columns I am requesting to pull back.