title: SQL> Combine two select statements
body: <p><strong>1</strong></p>
  
  <pre><code>SELECT v.NAME,
    CASE 
      WHEN va.state_territory_province = 'Illinois'
        THEN 'Illinois'
      END Vendors
  FROM grocery.vendor v
  INNER JOIN grocery.vendor_address va ON va.vendor_id = v.vendor_id
  WHERE va.state_territory_province = 'Illinois';
  </code></pre>
  
  <p><strong>2</strong></p>
  
  <pre><code>SELECT vendor_id,
    CASE 
      WHEN count(DISTINCT product_id) &gt; 2
        THEN 'High'
      END
  FROM grocery.can_supply
  HAVING count(DISTINCT product_id) &gt; 2
  GROUP BY vendor_id
  ORDER BY vendor_id;
  </code></pre>
  
  <p>The question I have to try and answer is:
  What are the full names of all vendors who can supply more than one item or are based in Illinois? </p>
  
  <p>I know how to write them separately, but I need to write them together and it is puzzling me.</p>
  
  <p>EDITED</p>
  
  <p>I tried to UNION and it gave me this error:</p>
  
  <blockquote>
    <p>*
    ERROR at line 1:
    ORA-00923: FROM keyword not found where expected</p>
  </blockquote>
  
  <pre><code>SQL&gt; SELECT vc.contact_name,
         CASE
           WHEN va.state_territory_province = 'Illinois'
             THEN 'Availible' 
         END CheckAvail
       FROM grocery.vendor_address va 
       INNER JOIN grocery.vendor_contact vc ON vc.vendor_id = va.vendor_id 
       WHERE va.state_territory_province = 'Illinois' union select vc.contact_name
           CASE
              WHEN count(distinct cs.product_id) &gt; 1 
                THEN 'Avail' 
           END CheckAvail from grocery.vendor cs;
  </code></pre>