title: How to compare column with arrays in BigQuery?
body: <p>I have two tables in BigQuery.</p>
  <p>Table <code>a</code> keeps values in arrays.
  Table <code>b</code> has row for each value
  I want to have all values from table <code>b</code> by id if at least one value not in array from table <code>a</code> by the same id</p>
  <pre><code>WITH a as (SELECT 1 as id, ['123', 'abc', '456', 'qaz', 'uqw'] as value
  UNION ALL SELECT 2, ['123', 'wer', 'thg', '10', '200']
  UNION ALL SELECT 3, null),
  b as (SELECT 1 as id, '123' as value
  UNION ALL SELECT 1, 'abc'
  UNION ALL SELECT 1, '456'
  UNION ALL SELECT 1, 'qaz'
  UNION ALL SELECT 1, 'uqw'
  UNION ALL SELECT 2, '123'
  UNION ALL SELECT 2, 'wer'
  UNION ALL SELECT 2, '10'
  UNION ALL SELECT 3, '200'
  UNION ALL SELECT 3, 'thg'
  )
  </code></pre>
  <p>What is the best way to make it?</p>