BigQuery在两个表上联接 [英] BigQuery JOIN on two tables

问题描述

我正在尝试运行以下查询，但继续遇到相同的错误

I'm trying to run the following query but keep on encountering the same error

查询失败 错误:在第6行第33列遇到".

Query Failed Error: Encountered "" at line 6, column 33. Was expecting one of:

查询是:

SELECT 1_0_MEMBER_GROUP.User_Group，
1_0_MEMBER_GROUP.Member_ID，
1_4_MEMBER_TRAN_YEAR.MEMBER_UID
FROM [Dataset1.1_0_MEMBER_GROUP]
JOIN [Dataset1.1_4_MEMBER_TRAN_YEAR]
在1_0_MEMBER_GROUP.Member_ID = 1_4_MEMBER_TRAN_YEAR.MEMBER_UID

SELECT 1_0_MEMBER_GROUP.User_Group,
1_0_MEMBER_GROUP.Member_ID,
1_4_MEMBER_TRAN_YEAR.MEMBER_UID
FROM [Dataset1.1_0_MEMBER_GROUP]
JOIN [Dataset1.1_4_MEMBER_TRAN_YEAR]
ON 1_0_MEMBER_GROUP.Member_ID = 1_4_MEMBER_TRAN_YEAR.MEMBER_UID

我无法弄清为什么它无法运行，必须要看的很简单.

I can't work out why it won't run and must be over looking something very simple.

推荐答案

您应该使用表别名.尝试

You should use a table alias. Try

SELECT member_group.User_Group, 
member_group.Member_ID, 
member_tran_year.MEMBER_UID 
FROM [Dataset1.1_0_MEMBER_GROUP] as member_group
JOIN [Dataset1.1_4_MEMBER_TRAN_YEAR] as member_tran_year
ON member_group.Member_ID = member_tran_year.MEMBER_UID

这篇关于BigQuery在两个表上联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！