copying between multiple tables

Question

I have some records in tables A with fields i.e firstname surname, lastname, school, dob

I have another table B with some records and fields i.e firstname, surname, address, club,

There are some records in table B which exists in table A

I'd like to use the firstname and surname in table B to check if the record exist in table A.

if it doesnt it should append the record to table A.

I would be glad if you can help me with this

Jochem van Dieten · Answer

INSERT INTO TableA (firstname, lastname .......)
SELECT
     firstname
     , lastname
     , ...
FROM
     TableB
WHERE NOT EXISTS (
     SELECT *
     FROM TableA
     WHERE
          TableA.firstane = TableB.firstName
          AND TableB.lastName = TableA.lastName
)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded