How to get all the data from table 1 and change the id values ​​to names from table 2?

Question

MySQL

How to get all the data from table 1, and so that the values ​​(productid) are replaced with names (title) from table 2?

Answer 1

SELECT  orders.id, products.title  
FROM orders LEFT JOIN products ON (products.id = orders.productid )

here you list everything you need to get - "SELECT orders.id, products.title ..... etc"

Answer 2

JOIN