连接两个表时出现语法错误

发布于 2025-01-12 18:59:11 字数 491 浏览 3 评论 0原文

(SELECT user_id, EXTRACT(MONTH FROM created_at) AS month, EXTRACT(DAY FROM created_at) AS day 
FROM marketing_automation_mail_logs
GROUP BY user_id, month, day) q1
INNER JOIN
(SELECT user_id, EXTRACT(MONTH FROM created_at) AS month, EXTRACT(DAY FROM created_at) AS day 
FROM referral_link_share_intents
GROUP BY user_id, month, day) q2
ON q1.user_id = q2.user_id
WHERE q1.month = q2.month AND q1.day = q2.day

我正在使用此查询来连接两个表，但它显示了 INNER JOIN 附近的语法错误。我不明白我哪里错了。

原文

(SELECT user_id, EXTRACT(MONTH FROM created_at) AS month, EXTRACT(DAY FROM created_at) AS day 
FROM marketing_automation_mail_logs
GROUP BY user_id, month, day) q1
INNER JOIN
(SELECT user_id, EXTRACT(MONTH FROM created_at) AS month, EXTRACT(DAY FROM created_at) AS day 
FROM referral_link_share_intents
GROUP BY user_id, month, day) q2
ON q1.user_id = q2.user_id
WHERE q1.month = q2.month AND q1.day = q2.day

I am using this query to join two tables but it shows me the syntax error near INNER JOIN. I don’t understand where I am going wrong.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

玩世 2025-01-19 18:59:11

用这个

select * from (
SELECT user_id, EXTRACT(MONTH FROM created_at) as month, EXTRACT(DAY from created_at) as day from marketing_automation_mail_logs
group by user_id, month, day) q1
INNER JOIN
(SELECT user_id, EXTRACT(MONTH FROM created_at) as month, EXTRACT(DAY from created_at) as day FROM referral_link_share_intents
GROUP BY user_id, month, day) q2
ON q1.user_id = q2.user_id
WHERE q1.month = q2.month AND q1.day = q2.day

use this

select * from (
SELECT user_id, EXTRACT(MONTH FROM created_at) as month, EXTRACT(DAY from created_at) as day from marketing_automation_mail_logs
group by user_id, month, day) q1
INNER JOIN
(SELECT user_id, EXTRACT(MONTH FROM created_at) as month, EXTRACT(DAY from created_at) as day FROM referral_link_share_intents
GROUP BY user_id, month, day) q2
ON q1.user_id = q2.user_id
WHERE q1.month = q2.month AND q1.day = q2.day

回复收藏 0 原文

~没有更多了~