title: How to use Except clause in Bigquery?
body: <p>I am trying to use the existing <code>Except</code> clause in Bigquery. Please find my query below</p>
  
  <pre><code>select * EXCEPT (b.hosp_id, b.person_id,c.hosp_id) from 
  person a 
  inner join hospital b
  on a.hosp_id= b.hosp_id
  inner join reading c
  on a.hosp_id= c.hosp_id
  </code></pre>
  
  <p>As you can see I am using 3 tables. All the 3 tables have the <code>hosp_id</code> column, so I would like to remove duplicate columns which are <code>b.hosp_id</code> and <code>c.hosp_id</code>. Simlarly, I would like to remove <code>b.person_id</code> column as well. </p>
  
  <p>When I execute the above query, I get the syntax error as shown below</p>
  
  <pre><code>Syntax error: Expected ")" or "," but got "." at [9:19]
  </code></pre>
  
  <p>Please note that all the columns that I am using in <code>Except</code> clause is present in the tables used. Additional info is all the tables used are <strong>temp tables created using <code>with</code> clause</strong>. When I do the same manually by selecting column of interest, it works fine. But I have several columns and can't do this manually.</p>
  
  <p>Can you help? I am trying to learn Bigquery. Your inputs would help</p>