title: List vendors, and lowest priced product SQL
body: <p>I am trying to join 2 tables and create a new field returning the lowest value of a product. I've tried many variations and can't seem to get it to work. </p>
  
  <pre><code>SELECT DISTINCT VENDOR.*, PRODUCT.P_PRICE, PRODUCT.LOWEST_PRICE AS MIN(PRODUCT.P_PRICE)
  FROM PRODUCT
  INNER JOIN VENDOR
  ON VENDOR.V_CODE = PRODUCT.V_CODE
  ORDER BY VENDOR.V_NAME
  </code></pre>