CREATE TABLE purchases (sales_details VARCHAR, purchase_details VARCHAR)
CREATE TABLE sales (sales_details VARCHAR, purchase_details VARCHAR)

What are the details of all sales and purchases?
SELECT sales_details FROM sales UNION SELECT purchase_details FROM purchases
SELECT "sales_details" FROM "sales" UNION SELECT "purchase_details" FROM "purchases"