BigQuery是否支持SubQueries? [英] Does BigQuery support SubQueries?
本文介绍了BigQuery是否支持SubQueries?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在我的SQL FROM子句中,我想通过子查询使用动态创建的表:
In my SQL FROM clause, I want to use a dynamically created table via a subquery:
Select A.Field1,B.Field2
FROM TableA as A, (select Field1,Field2 from TableB) B
Where A.Field1 = B.Field1
BigQuery是否支持这个功能?
Does BigQuery support this?
推荐答案
您不需要子查询这:
You don't need a subquery for this:
Select A.Field1,B.Field2
FROM TableA as A join
TableB as B
on A.Field1 = B.Field1;
但是,根据参考手册,BigQuery支持子查询。
But yes, according to the reference manual, BigQuery does support subqueries.
这篇关于BigQuery是否支持SubQueries?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文