Where Not Exists... Sort of....

[prees959]

Hi ,

I have an existing table that I am loading in:

RefNo
840420110602
840420110619
840420110664
840420110671
840420110688
840420110695
840420110701
840420110718

I then load in a new batch of codes :

RefNo
840420110602
840420110619
840420110664
840420110671
840420110688
840420110695
840420110701
840420110718
840420110725
840420110732
840420110749
840420110756
840420110763

I need to be only left with :

840420110725

840420110732

840420110749

840420110756

840420110763

As I need to run these through a check process.  Can anyone assist with the correct script for this please?

Many thanks,

Phil

[Vegar · Accepted solution]

What do you mean by "sort of...."

Your example looks like it could be solved by just a where not exsists Like below. Please explain.

OldRefs:

Load

RefNo as exsistingRefNo

From table1;

NewRefs:

Load

RefNo 

From table1 

Where not exsists(exsistingRefNo, RefNo);

Drop table OldRefs;

[Brett_Bleess · Accepted solution]

Phil, did Vegar's post help you get what you needed?  If so, do not forget to return to the thread and use the Accept as Solution button on his post to give him credit for the assistance and to let other Community Members know this worked for you.  If you still have further questions etc., leave us an update.

Regards,
Brett