There all sorts of different data in them...some text fields, some dates, etc. The rows in table B are never exactly the same. Im not concerned as to which piece...

I have tried that but there are quite a few columns and a decent amount of records, so the distinct is very costly. It does work, but I was...