I would probably create a view by joining dealer list and last weeks transactions (use distinct or subquery to avoid duplicate entries) and use this view as a source for...