insert

[pm]

hi, my task= insert * from table B into table A where the records in table
B doesn't exist in table A.

hilfe.

[Dale]

To get the records in tableB that are not in A:
SELECT * FROM tableB LEFT JOIN tableA
ON tableB.ID = tableA.ID
WHERE tableA.ID IS NULL

You can then insert those records into tableA:
INSERT INTO tableA
SELECT * FROM tableB LEFT JOIN tableA
ON tableB.ID = tableA.ID
WHERE tableA.ID IS NULL

"pm" <pontolan@hotmail.com> wrote:
>
>hi, my task= insert * from table B into table A where the records in table
>B doesn't exist in table A.
>
>hilfe.