title: SQL Syntax NOT IN for Google BigQuery
body: <p>The Google SQL syntax guide found here
  <a href="https://developers.google.com/bigquery/docs/query-reference" rel="noreferrer">https://developers.google.com/bigquery/docs/query-reference</a>
  does not seem to address use of the NOT IN terminology.</p>
  
  <p>I get the error</p>
  
  <pre><code>Query Failed
  Error: Encountered "" at line 0, column 0. Was expecting one of:  
  </code></pre>
  
  <p>(and then Google lists nothing after the words 'one of')</p>
  
  <p>when my query is</p>
  
  <pre><code>SELECT ageinmonths,amountborrowed,borrowerrate,creationdate,creditgrade,
         debttoincomeratio,groupkey,key,lenderrate,listingkey,modifieddata,
         originationdate,prosperrating,status,term
  FROM prosperloans1.loans2 as big,
       prosperloans1.dupelistingkeysinloans2 as small
  WHERE big.listingkey NOT IN small.listingkey
  </code></pre>
  
  <p>the table 'small' has 14 rows.  The table big has 57K rows.</p>
  
  <p>Any ideas?
  Not sure if Google SQL supports NOT IN.</p>
  
  <p>Thanks
  Shawn</p>