Could you please post the scripts for the two tables in the problem and enough inserts statements to recreate the problem you are having? If you ask a question and include code to create an populate the tables in your problem, you are more likely to get tested solutions instead of haphazard guesses. Go ahead and obfuscate your data if you need to, but if we have nothing to work with, it's really hard to come up with a solution that will actually work.