How to copy data from 2 tables into one?

Question

MySQL

INSERT into archive (title_product, title_category, price_product) 

SELECT title from product, 
SELECT title from category, 
SELECT price from product;

Separately insert and select work. How to merge into one request?

Answer 1

Correctly build a selection from the desired tables.

INSERT into archive (title_product, title_category, price_product) 
SELECT p.title, c.title, p.price
  from product p
   join category c on p.category_id = c.id