How to compare fields from different tables?

Question

MySQL

Friends, the initial knowledge
is the task of making a price comparison table by the name of the product.
Available:
tab1: name, price
tab2: name, price
how to implement a price comparison table for all products?
name1 -price1 - price2 name2
-price1 - price2
How to make a comparison so that there are different prices opposite the name?

Answer 1

Select t1.name1, t.1price1, t2.price2 from table 1 as t1
left join t2 on t1.name = t2. name
like this