How to select data from multiple tables (not so easy :) )?

Question

MySQL

Welcome all! Here is such an interesting query that needs to be built, I don’t understand how:(
The essence (in short): there are two tables:
The first is
id, field_name
The second
is field_id,
value of this column - value from the second?Something like SELECT table2.value AS table1.field_name :)
Is it even possible in MySQL framework?

Answer 1

select table1.field_name, table2.value FROM table1 LEFT JOIN table2 ON table1.id=table2.field_id;