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

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"