append table problems

[Sparky]

hi,

i tried doing a delete query earlier on and it still doesnt work, so this is the latest idea.

I have two tables of data, both of which have a unique number, which may be on both tables.

I want to run an append query which will take all of the records on one table, EXCEPT those which are on the second table. Please help me with this one as i am getting really frustrated as the NOT expression seems not to work.

I have tried = NOT [ value on second table ] in the criteria, but it doesnt work?? why?

thanks a lot.
Sparky

[PilgrimPete]

First off, did you try the UNION query?

Second, try this:

SELECT Fields
FROM Table1
LEFT JOIN Table2
ON Table1.UniqueID = Table2.UniqueID
WHERE Table2.UniqueID IS NULL

(You might need a RIGHT join, I can never visualise the way they work and invariably get them back to front!)