我有这个表,我想选择所有不同的用户id值,其中有一个event='AAAAAAAAAA'和event='xxxxxxxxx'(即,唯一的结果应该是用户id=123456789)
unique_row_id user_id event event_timestamp
----------------------------------------------------------------
0 123456789 AAAAAAAAAA 2010-01-20 15:00:00
1 123456789 abcdefghij 2010-01-20 15:00:05
2 123456789 XXXXXXXXXX 2010-01-20 15:00:15
3 987654321 AAAAAAAAAA 2010-01-20 16:00:00
4 987654321 abcdefghij 2010-01-20 16:00:05
5 987654321 abcdefghij 2010-01-20 16:00:15
6 111111111 XXXXXXXXXX 2010-01-20 16:01:00
7 111111111 XXXXXXXXXX 2010-01-20 16:01:05
8 111111111 XXXXXXXXXX 2010-01-20 16:01:15
我都试过了:
SELECT distinct user_id from mydata where event='AAAAAAAAAA' and event='XXXXXXXXXX'
它给了我一个空的结果集,并且
SELECT distinct user_id from mydata where event='AAAAAAAAAA' or event='XXXXXXXXXX'
给了我一切。有什么建议吗?我想我得走“加入”这条路,对吗?