Can you show me the phone numbers of all customers?
select customer_phone from customers
Hmm, I also want to know the phone numbers of all suppliers please.
select supplier_phone from suppliers
Please list the phone numbers of all customers and suppliers.
select customer_phone from customers union select supplier_phone from suppliers