How to make a third table using the same column from two tables in SQL?

Question

SQL

We have two tables:

title   | deposit
----------------
Title 1 | 0.1
Title 2 | 0.2

post_id | title
-----------
1  | Title 1
2  | Title 2

From these two tables, you need to get the third one:

post_id | title   | deposit
----------------------
1  | Title 1 | 0.1
2  | Title 2 | 0.2

If possible, I would like to do without PHP.

Answer 1

SELECT
    table2.post_id as post id,
    table2.title as title,
    table1.deposit as deposit
FROM table2
    LEFT JOIN table1
        ON table2.title = table1.title//джойн по тайтлу; в зависимости от вида хранящихся строк возможно стоит делать приведение к нижнему регистру, удаление пробелов и т.д.

PS It would be better if the join was performed on indexed numeric fields (for the sake of performance).

Answer 2

JOIN