Something like

INSERT INTO TableA
SELECT * FROM TableB 
WHERE PK NOT IN (SELECT PK FROM TableA)

>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