I've created aliases for each of the other lists that the master table looks at and do the join on them.<BR><BR>The following query works mostly okay, except for the where clauses at the bottom ...