Thanks for the responses.

I was aware of the SELECT WHERE NOT IN but noticed how unbearably slow it could be, the WHERE NOT EXISTS was instant, but I had my doubts about it working.

Thanks anyway
Kev