Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorry it was quite easy using 'where not exists(ID)' so this is working now. thanks.