how to combine 2 tables in MySQL
create table yourTableName ( select *from yourTableName1 ) UNION ( select *from yourTableName2 );
Source: www.tutorialspoint.com
how to relationship query two different tables in MySQL
SELECT product_name, customer.name, date_of_sale FROM sales, product, customer WHERE product.product_id = sales.product_id AND customer.customer_id >= sales.customer_id LIMIT 0, 30
Source: www.plus2net.com