'How do i make a new table out of two existing tables in mysql

Create a new table (order_id, customer_name and order_date) by joining two tables(order_id, customer_id and order_date) and (customer_id, customer_name, contact_name, country)

I have to do this for a class and have been trying to do it for a while but cant find a solution. How do i do this? Thanks



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source