How to properly join SQL tables?

Question

MySQL

there is a NAME table

there is a PRIC table

Help me write a query that displays the following information from the NAME and PRIC tables:
Employee name; The address; Salary
But if the salary for one of the employees is not specified, then in the resulting selection in the Salary field, you must specify 0.

Answer 1

SELECT
    n.`Name`,
    n.`Address`,
    CASE 
        WHEN p.`Zarp` IS NULL THEN 0
        ELSE p.`Zarp`
    END as `Zarp`
FROM `NAME` n
LEFT JOIN `PRIC` p ON n.`Name` = p.`Name`

PS: Not the best solution to bind by varchar. The connection will be many to many, and duplicates will fall. Deliver the identifier to the first table by primary key, and in the second secondary and on them JOIN, communication will be one to one.