Hi All,
I have 2 QVD's ( week & month) which I want to consolidate in to one.
The only thing is there are records in both that have the same ID, the way it should work is to load everything from 'week' and only those from 'month' where the ID does not exist in 'week'.
I know there's an exists statement but not sure how to code it so that I achieve what I'm trying to do, if anyone can help it would be much appreciated.
Many thanks,
Phil
