title: SQL MINUS result to include other columns in result
body: <p>I get the records I need with the below select statement, which is the CAR_COLOR from the CARS_PRIMARY table that don't exist in the CAR_SECONDARY table (also has CAR_COLOR column), but how do I now include the other matching columns for the results, so it retuns the additional columns associated with the results of the select statement below</p>
  
  <pre><code>SELECT CAR_COLOR
  FROM CARS_PRIMARY
  MINUS
  SELECT CAR_COLOR
  FROM CARS_SECONDARY
  </code></pre>
  
  <p>Currently the results
  are </p>
  
  <pre><code>PINK
  BLUE
  GREEN
  </code></pre>
  
  <p>I need</p>
  
  <pre><code>PINK   SUV    4DOOR      
  BLUE   CAR    2DOOR
  GREEN  TRUCK  2DOOR
  </code></pre>