How can I sum columns from 2 tables and display in the summary?

Question

MySQL

There is a PRIC table and an
AMO table.
How to write a query that displays the following information from the PRIC and AMO tables:
Employee name; The total amount paid (the amount from the first table and the second)
But if there were no payments for one of the employees, then 0 should be indicated in the field with the total amount paid.

Answer 1

SELECT a.name
       sum(a.zarp)
  FROM (SELECT name, 
               IFNULL(zarp, 0) zarp 
  	      FROM PRIC
        union all
        SELECT name, 
               IFNULL(amount, 0) zarp 
          FROM AMO
       ) A
 GROUP BY a.name

Answer 2

SELECT PRIC.Name, PRIC.Zarp + ( SELECT SUM( Amount ) FROM AMO WHERE AMO.Name = PRIC.Name ) FROM PRIC

Answer 3

something like this:

select Name, sum(Amount) from (
  select Name, Amount from AMO
  union all
  slect Name, Zarp as Amount from PRIC
) group by Name