ClickHouse左连接

全栈程序员站长

发布于 2022-11-04 19:46:48

85100

代码可运行

文章被收录于专栏：全栈程序员必看全栈程序员必看

运行总次数：0

代码可运行

大家好，又见面了，我是你们的朋友全栈君。

A左连接B===>S1区域

1、等价方式一

SELECT 
date, 
ts, 
country, 
province, 
city,
ye_no
FROM
(SELECT 
date, 
ts, 
country, 
province, 
city,
0 AS yes_no
FROM DBa.tba 
WHERE (date = today()-1) 
)
ALL LEFT JOIN 
(SELECT 
date, 
ts, 
country, 
province, 
city
FROM DBb.tbb  
WHERE (date = today()-1)
AND cid != '1sk309'
) USING ( date, ts, country, province, city)

2、等价方式二

SELECT 
date, 
ts, 
country, 
province, 
city,
ye_no
FROM
(SELECT 
date, 
ts, 
country, 
province, 
city,
0 AS yes_no
FROM DBa.tba 
WHERE (date = today()-1) 
) AS A
ALL LEFT JOIN 
(SELECT 
date, 
ts, 
country, 
province, 
city
FROM DBb.tbb  
WHERE (date = today()-1)
AND cid != '1sk309'
) AS B
ON ( A.date=B.date, A.ts=B.ts, A.country=B.country, A.province=B.province, A.city=B.city)

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/191844.html原文链接：https://javaforall.cn

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2022年9月19日，如有侵权请联系 cloudcommunity@tencent.com 删除

https