append Query - no duplicates

[diegomarino]

Hi,
this is a very sensitive operation for me so i'm asking to be sure, i found some solution but i'm not so sure about that


i have a LOCAL TABLE
name/position/company/City/market/Sector/contract/connected on/message date/subject/content/folder/to contact in/not in db/not interesting
this table was created adding fields to the exportation of linkedin data


now i'd like to import other data from linkedin and add that people to my LOCAL TABLE that i have not already imported. the structure of LINKEDIN IMPORT (a query that i built to merge all data from linkedin) is this
name/position/company/connected on/message date/subject/subject/folder




the question is:
i want to check by name and position if i have already in my LOCAL TABLE this person, and if not add it. other issue, if i have already this person but the message date field in my LOCAL TABLE has no date in it or a date less recent, i'd like to add the date message from my LINKEDIN DATA.

is it possible?
i have a database too but there is name of linkedin contacts, i dunno if it's ok , if it is i can attach it

[ArviLaanemets]

You need to run 2 queries - an Append query, and an Update query. Like

INSERT INTO YourLocalTable (Name, Position, Company, ConnectedOn, MessageDate, Subject, Folder)
SELECT lin.*
FROM
     YourLinkedinTable lin (LEFT JOIN YourLocalTable loc ON loc.Name = lin.Name AND loc.Position = lin.Position)
WHERE loc.Name Is Null

UPDATE YourLocalTable
SET MessageDate = lin.MessageDate
FROM
     YourLinkedinTable lin (LEFT JOIN YourLocalTable loc ON loc.Name = lin.Name AND loc.Position = lin.Position)
WHERE loc.MessageDate Is Null AND lin.MessageDate Is Not Null

[diegomarino]

looks like the solution, but what is "lin"?

[ArviLaanemets]

looks like the solution, but what is "lin"?

An alias for YourLinkedinTable.

[diegomarino]

An alias for YourLinkedinTable.

sorry, dumb question