>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

Do you want to insert or update?

For insert

INSERT into TableA (F1, F2, F3)
select F1, F2, F3 from TableB
where not exists (select 1 from TableA where TableA.F1 = TableB.F1)