google-bigquery - 如何克服连接联合表与其他表的错误

Question

当我们尝试将一侧的联合表与另一侧的其他表连接时，

SELECT A.x,B.y FROM ([DataSet.Liad],[DataSet.Livne]) AS A INNER JOIN [DataSet.Names] AS B ON A.ID = B.ID LIMIT 10

我们得到这个错误:

Error: 2.1 - 0.0: JOIN cannot be applied directly to a table union or to a table wildcard function. Consider wrapping the table union or table wildcard function in a subquery (e.g., SELECT *).

为了解决这个错误，我建议你使用一个 View 。
将此联合查询保存为 View DataSet.LiadLivne:

SELECT * FROM [DataSet.Liad],[DataSet.Livne] 

使用 View 执行原始查询:

SELECT A.x,B.y FROM [DataSet.LiadLivne] AS A INNER JOIN [DataSet.Names] AS B ON A.ID = B.ID LIMIT 10

享受

Answer 1

你需要写成:

SELECT A.x,
       B.y
FROM
  (SELECT A.x
   FROM ([DataSet.Liad],[DataSet.Livne])) AS A
INNER JOIN [DataSet.Names] AS B ON A.ID = B.ID LIMIT 10