1create table yourTableName
2(
3 select *from yourTableName1
4)
5UNION
6(
7 select *from yourTableName2
8);
1SELECT product_name, customer.name, date_of_sale
2FROM sales, product, customer
3WHERE product.product_id = sales.product_id
4AND customer.customer_id >= sales.customer_id LIMIT 0, 30