Please see how to solve this problem in the stored procedure. Thank you

photo_dl

Example: A record already exists in table a1:
a b c d e
-----------------------------
Haikou Hainan Province China 20

Then the a1 table and the b1 table are associated to take out the following data
a b c d e
---------------------------------------
Haikou, Hainan Province, China 20 5 (d / f, (f is the result of table b1))
Haikou, Hainan, China 20 0.67 (d / f, (f is the result of table b1))

Requirement: How can the data obtained from tables a1 and b1 overwrite existing records in table a1, and how to append another record to table a1

Thank you!

sanshuimei

insert into a1 as
select .......
minus
select ...... a1 ....

or
insert into a1 select ......
where not exist (select .... from a1 ....)

photo_dl

Can the upstairs write the code clearly? I can't understand