首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >大型查询SQL。合并列相同的表(无主键)

问大型查询SQL。合并列相同的表(无主键)
EN

Stack Overflow用户
提问于 2017-07-19 00:02:35
回答 1查看 193关注 0票数 0

我正在尝试将3+ NOAA GSOD数据表组合在一个超级表中。I正在尝试将stations表连接到结果数据上,然后按国家/地区进行过滤。

我只能对一个表执行此操作,但不能对更多表执行此操作。下面是我修改代码以实现这一点的尝试。我尝试了几种不同的修改,但都没有成功:

代码语言:javascript
复制
SELECT * FROM [bigquery-public-data:noaa_gsod.gsod2016] AS gsod2016, 
[bigquery-public-data:noaa_gsod.gsod2015] AS gsod2015 JOIN [bigquery-public-
data:noaa_gsod.stations] AS stations ON gsod2016.stn = stations.USAF AND 
gsod2015.stn = stations.USAF WHERE stations.country = "CB"

NOAA GSOD bigquery数据:https://bigquery.cloud.google.com/table/bigquery-public-data:noaa_gsod.gsod2016

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2017-07-19 00:22:47

使用1个标准的inner或,(最好是inner语法)并确保表的顺序正确,除非在ON上定义了表的‘,否则不能在表上进行连接。

代码语言:javascript
复制
SELECT * 
FROM [bigquery-public-data:noaa_gsod.stations] AS stations 
INNER JOIN [bigquery-public-data:noaa_gsod.gsod2016] AS gsod2016
  ON gsod2016.stn = stations.USAF 
INNER JOIN [bigquery-public-data:noaa_gsod.gsod2015] AS gsod2015 
  ON gsod2015.stn = stations.USAF 
WHERE stations.country = "CB"

现在,所有这些都表明,您是真的想要连接,还是想对数据执行UNION ALL操作并添加一年

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/45171933

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档