Is there a way to “update” a table from another table appending or inserting only items that are not already in the target table with one function?
Currently I create a cursor containing only those values not already in the target table, then scan it and do the insert function.

This seems a little like brute force. Is there a more elegant way?

I was looking at Update – SQL, but it seems it can only change existing field values.

I was thinking something along these lines;

Insert into A ;
(F1, F2, F3) ;
Where !F1 IN (select B.F1 from B)
Values ;
(B.F1, B.F2, B.F3)

Thanks in advance

Gary