Forum Discussion
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.
3 Replies
SivaMani can you please share the error and the headers of the 2 tables.
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..
Hi Siva Mani
Problem is know by microsoft but they don't want to fix ;>)
Don't hezitate to communicate
It's a nightmare for my company
