Joining tables with Bigquery Mat

Joining tables with Bigquery Materialized View - Stack Overflow
I have data like this:IDTextResultI Want1abcnullPassed1PassedPassedPassed1defnullPassed2gh
Joining tables with Bigquery Materialized ViewStack Overflow
admin20小时前
10