I want to select many columns from many tables without foreign key

I have three tables, and I want to fetch the three table data without a foreign key. Say I have a table product_1 which contains (id, name) and table product_2 contain (id, name, price). I want to select the columns of the two tables in one query. I am asking if there are any MySQL query to select many columns from many tables? This is my code: SELECT name FROM product1 AND price FROM product2;