我有一个表 t_user(username,gender,date); username和date为主键
我查询date为'2008-07-02' 的用户名,
我怎么得到date为'2008-07-03'的用户名且该用户在date为'2008-07-02'中存在。
我用的是mysql数据库
[code="sql"]mysql> create table t_user(username varchar(20), gender varchar(20), date dateti
me);
Query OK, 0 rows affected (0.08 sec)
mysql> insert into t_user values('1', '11', '2008-02-01');
Query OK, 1 row affected (0.02 sec)
mysql> insert into t_user values('2', '22', '2008-02-02');
Query OK, 1 row affected (0.00 sec)
mysql> insert into t_user values('1', '33', '2008-02-03');
Query OK, 1 row affected (0.00 sec)
mysql> select * from t_user t where t.date = '2008-02-01' and t.username in (select tt.username from t_user tt where tt.date='2008-02-03');
+----------+--------+---------------------+
| username | gender | date |
+----------+--------+---------------------+
| 1 | 11 | 2008-02-01 00:00:00 |
+----------+--------+---------------------+
1 row in set (0.03 sec)[/code]
就直接
[code="java"]select * from t_user where date='2008-07-02' group by username [/code]
这样不行吗？