I know there are a few ways to do this, but I'm having a brain fart and I'm unsure what the simplest SQL would be.
Basically, I have a table of product brands and a table of products. There can be many products to each brand. On my website I only want to display links to brands that actually have products. So I want a simple query that will select the name of each brand whose ID is referenced in the products table.