A table contains business_name and town. There are 45 businesses but only 24 towns. I would like a query that lists the business_name and town for only towns that have more than one business_name.
I should know how to do this, but I'm drawing a blank...