MySQL. How to combine fields with the same data from different tables in a query?

Question

MySQL

There is a database computer_company , it has 4 tables (which can be seen in the picture).
The task is:
"Find the model numbers and prices of all products (of any type) released by the ASUS manufacturer."
Here's what I got:

SELECT product.model, pc.price, laptop.price, printer.price
FROM product
INNER JOIN pc ON product.model = pc.model
INNER JOIN laptop ON product.model = laptop.model
INNER JOIN printer ON product.model = printer.model
WHERE product.maker LIKE "ASUS";

Outputs Empty set , which is not surprising.
I need to merge the price fields from all three tables into one. How can I do that?

Answer 1

Basically, you've already done everything. Empty set apparently means that the request returned an empty set. If it bothers you that the fields are named the same, then there is the as keyword:
The query returns an empty set, most likely due to INNER JOIN, because when using it, it is required that all three tables simultaneously have data corresponding to each row from the table specified in from, which, apparently, is not the case in your case.
Use OUTTER JOIN aka LEFT JOIN.