sql - BigQuery SQL 通过公共变量连接多个表/子查询的最佳实践

Question

通过 BigQuery SQL 中的公共变量连接多个表的最有效（或最佳实践）方法是什么？

迄今为止，我一直在使用类似于以下内容的查询：

select * from

    (select * from

        (select * from (
          subquery1
        ) 
        where criteria is true
        inner join table1 using(var)
    )
    where criteria is true
    inner join table2 using(var)
)

inner join table3 using(var)

标签： sqlgoogle-bigquery

Answer 1

考虑以下选项

select * from (
  subquery1
) 
join table1 using(var)
join table2 using(var)
join table3 using(var) 
where all_criterias is true

另请查看https://cloud.google.com/bigquery/docs/release-notes#August_19_2020