title: SQL to Django Translation
body: <p>This statement works in SQL, I just cannot figure out how to convert it to django. Im sure it uses prefetch_related, Prefetch, or select_related but im still having a hard time understanding those concepts.  I do see that prefetch basically has to have the field under that table.</p>
  <p>My goal: Not all brands have products. All products have brands. Show my only brands with products. I was hoping to implement <code>Brand.objects.[insert-filter-here]</code></p>
  <p>Model.py (appended version of actual models.py file)</p>
  <pre><code>class Product(models.Model):
      brand = models.ForeignKey(Brand)
  
  class Brand(models.Model):
      name = models.CharField
  </code></pre>
  <p>SQL</p>
  <pre><code>SELECT DISTINCT products_brand.name FROM produts_brand INNER JOIN products_product on products_brand.id=products_product.brand_id;
  </code></pre>
  <p>Its 2 tables becuase the products table has many many columns (27), I guess the other option is to just
  combine them. But I wanted more control over Brand objects for ease of lookup/editing.</p>
  <p>Many thanks for your help!</p>