且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

mySQL INNER JOIN和UNION ALL一起

更新时间:2023-02-05 11:38:31

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