Forum Discussion

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Merge Query Error: Unable to merge BigQuery tables

I'm trying to merge two tables based on three column. I'm receiving an error like Something went wrong.    
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

SivaMani can you please share the error and the headers of the 2 tables.

  • SivaMani's avatar
    SivaMani
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Anonymous,

     

    Thanks for the reply. I found a temporary solution.

     

    But, I'm getting this error when I use fields from the merged table,

     

    Error Message:
    OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: LEFT OUTER JOIN cannot be used without a condition that is an equality of fields from both sides of the join..