Currently, I want to update my database for the newest one. I have two databases. One is A2, and another is A3.
A2 is the newest database, and it has 3 records.
A3 is the previous database, and it has 4 records.
How can I overwrite the A3 to as same as A2(same record numbers)?
Thank you.
I use SQL as
Code:
INSERT INTO A3 ( Type, Name, Strength, Production, Code, Sales)SELECT DISTINCT A2.Type, A2.Name, A2.Strength, A2.Production, A2.Code, A2.Sales
FROM A2 INNER JOIN A3 ON A2.Code=A3.Code
WHERE A2.Code Is Null;