Skip to Content
Former Member
Jun 01, 2005 at 06:49 PM

looping through business partners


I need to run a query that shows which BPs have NOT had a recent delivery. Therefore, I am searching for values not present. I have decided to run a subquery pulling up all deliveries within the last month and then looping through all BPs to see if they are in that query. If not, I want to display their name as part of the result. I am not sure how to loop through BPs in SQL using Query Generator. Any idea of syntax?

Thank you in advance for you help!