mySQL INNER JOIN和UNION ALL一起

本文介绍了mySQL INNER JOIN和UNION ALL一起的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个表，其中如果日期和类别"bar"匹配则对行进行分组，现在我需要对其他表进行 INNER JOIN 并使用 WHERE answer ='2'从该表开始，但我不知道该怎么做.

I have a table with rows that's grouped if the date and the category 'bar' matches, now I need to INNER JOIN these with another table and use a WHERE answer = '2' from that table, but I don't know how to do that.

SELECT category, date, client FROM sbs_events WHERE category <> 'bar' UNION ALL SELECT category, date, MIN(client) AS client FROM sbs_events WHERE category = 'bar' GROUP BY category, date

我制作了 SQL小提琴

我需要添加到小提琴中的东西是

The thing I need to add to the fiddle is

INNER JOIN sbs_userEvents ON sbs_events.id = sbs_userEvents.event_id WHERE answer = 2 AND user_id = 1

但是由于我已经有一个 WHERE category ='bar'，所以我不知道如何添加它.

But since I already have a WHERE category = 'bar' I don't know how to add this.

推荐答案

SELECT category, date, client FROM sbs_events INNER JOIN sbs_userEvents ON sbs_events.id = sbs_userEvents.event_id WHERE category <> 'bar' AND answer = 2 AND user_id = 1 UNION ALL SELECT category, date, MIN(client) AS client FROM sbs_events INNER JOIN sbs_userEvents ON sbs_events.id = sbs_userEvents.event_id WHERE category = 'bar' AND answer = 2 AND user_id = 1 GROUP BY category, date