title: MySQL: Select Distinct from 2 different tables?
body: <p>I have 2 different tables that each have a column called <strong>product_type</strong>. How can I get the DISTINCT values of product_type across both tables? Just to clarify, if both tables have a product_type of "diamond" I only want it returned once. Basically as if both tables where combined and I selected distinct product_type from it.</p>
  
  <p>Thanks!!</p>