Thanks guys. It looks like it would be safer to take a longer route via a temp table. You have probably save me from a disaster as the table to load properly would include 10,000s of records.
However, out of curiosity I may try using DISTINCT on an standalone test computer if I get the chance.
Thanks