Quick SQL merge question

[GGcpp]

Hope I finally got the right forum

I have this SQL problem. I’m a C++ guy who's database experience is limited to basic Select commands. I boasted this should be easy but realized how long ago I did any 'real' SQL commands. I know this is easy stuff for the gurus
Note, I am under Access (MDB) usually do stuff in C++ (one row at a time) but I know this is easy and hope to learn something.

I need to update a table (user) with data contained in another table (latest user info)

Here is my problem in ‘C’ like pseudo-code:

//I have 2 similar tables, ‘Master’ and ‘Updates’
// Step 1: update / merge (join?)
if (Master.numberId == Updates.MasterNumber)
{
    Master.total_global = Updates.tglobal
    Master.ACTION_text += Updates.ACTION_text
    Master.fact = Updates.fact
}

// Step 2: add new entries
if(Updates.MasterNumber ‘is not in’ Master.numberId)
{
    Insert into Master( field1, field2, field3, ...)
    Select * from  Updates where MasterNumber  == Updates.MasterNumber
}

 

[PHV]

SQL code:

UPDATE Master INNER JOIN Updates ON Master.numberId = Updates.MasterNumber
SET Master.total_global = Updates.tglobal
, Master.ACTION_text = Master.ACTION_text & Updates.ACTION_text
, Master.fact = Updates.fact

INSERT INTO Master (field1, ..., fieldN)
SELECT col1, ..., colN FROM Updates
WHERE MasterNumber NOT IN (SELECT numberID FROM Master)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[GGcpp]

A big THANK YOU to PHV, worked on first try.

I remember why I decided to go C++ instead of database after school

A big Merci from Snowy Montréal