Skip to content
Advertisement

Google BigQuery: join on an join Alias

i try to perform an join on a table that is the result of an other join. But i recieve the error: Table “join_1” must be qualified with a dataset (e.g. dataset.table). I bolded the Problem. Thanks a lot in advance.

How can I qualify table join_1? I edited the table, I hope that helps to understand the problem more. Thanks a lot, you guys reply that fast, you guys are awesome.

Advertisement

Answer

I found the answer to my Problem, but I was only able to find it, because of your “with clause” hint, samuel. So, thanks a lot, Samuel. But I will post the answer here, I have put all Joins into With clauses just the last one i did in the SELECT.

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement