title: BigQuery JOIN on two tables
body: <p>I'm trying to run the following query but keep on encountering the same error</p>
  
  <blockquote>
    <p>Query Failed
    Error: Encountered "" at line 6, column 33. Was expecting one of:</p>
  </blockquote>
  
  <p>The query is:</p>
  
  <blockquote>
    <p>SELECT 1_0_MEMBER_GROUP.User_Group,
    <br/>       1_0_MEMBER_GROUP.Member_ID,
    <br/>       1_4_MEMBER_TRAN_YEAR.MEMBER_UID 
    <br/>FROM [Dataset1.1_0_MEMBER_GROUP] 
    <br/>JOIN [Dataset1.1_4_MEMBER_TRAN_YEAR] 
    <br/>ON 1_0_MEMBER_GROUP.Member_ID = 1_4_MEMBER_TRAN_YEAR.MEMBER_UID</p>
  </blockquote>
  
  <p>I can't work out why it won't run and must be over looking something very simple.</p>