title: SQL - ALL, Including all values
body: <p>I have two tables:</p>
  
  <pre><code>create table xyz
  (campaign_id varchar(10)
  ,account_number varchar)
  
  Insert into xyz
  values ( 'A', '1'), ('A', '5'), ('A', '7'), ('A', '9'), ('A', '10'),
         ( 'B', '2'), ('B', '3'),
         ( 'C', '1'), ('C', '2'), ('C', '3'), ('C', '5'), ('C', '13'), ('C', '15'),
         ('D', '2'), ('D', '9'), ('D', '10')
  
  
  create table abc
  (account_number varchar)
  
  insert into abc
  values ('1'), ('2'), ('3'), ('5')
  </code></pre>
  
  <p>Now, I want to write a query where all the four account_number <code>1, 2, 3, 5</code> are included in a <code>Campaign_id</code>. </p>
  
  <p>The answer is C.</p>
  
  <p>[My aim is to find the Campaign Code that includes account_number 1, 2, 3 &amp; 5. This condition is only satisfied by campaign code C.]</p>
  
  <p>I tried using <code>IN</code> and <code>ALL</code>, but don't work. Could you please help.</p>