Can you give us table DDL for your 3 tables as well as some sample data for the two that you need to compare?
John Rowan
======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden