How to Update with SQL EXISTS(?)

[Hitcher]

Hi,
I have 2 tables in an SQLServer db.
I want to compare table A with table B and add any records that EXIST
in table B but dont exist in table A, to table A.
Can anyone help me with the SQL?
TIA
Hitcher

[John Gilson]

"Hitcher" <st*************@hotmail.com> wrote in message
news:2f**************************@posting.google.c om...

Hi,
I have 2 tables in an SQLServer db.
I want to compare table A with table B and add any records that EXIST
in table B but dont exist in table A, to table A.
Can anyone help me with the SQL?
TIA
Hitcher

Here's the general idea.

CREATE TABLE A
(
col INT NOT NULL PRIMARY KEY
)

CREATE TABLE B
(
col INT NOT NULL PRIMARY KEY
)

INSERT INTO A (col)
SELECT col
FROM B
WHERE NOT EXISTS (SELECT *
FROM A
WHERE col = B.col)

Regards,
jag