Hi Rico. >The extra constraints in the WHERE will affect rows returned by this query. That may be ok for you but it makes the joins not purely left. I don't understand. Where can those constraints go? That is the only spot where they can be place, correct?