第二个是表格B。请帮帮我。
我在mysql中有这个表:
表a
sentid | eventid | a | sentiment |
-------------------------------------------
1 | 10 | yes | pos |
2 | 10 | so | neu |
3 | 11 | me | neu |
4 | 11 | luv | pos |
5 | 11 | so | neu |
bid | eventid | b | sentiment |
-------------------------------------------
1 | 11 | hee | pos |
2 | 11 | yup | neu |
3 | 10 | so | neu |
4 | 10 | ha | neu |
5 | 10 | no | neu |
eventid | sentiment | cnt |
-------------------------------
10 | pos | 1 |
10 | neu | 1 | #from tablea
10 | neu | 3 | #from tableb
期望输出
eventid | sentiment | cnt |
-------------------------------
10 | pos | 1 |
10 | neu | 4 |
我的代码:
select id,sentiment,count(*) as cnt from tablea WHERE id=10 group by sentiment
union all
select id,sentiment,count(*) as cnt from tableb WHERE id=10 group by sentiment
