这句SQL查询怎么写?
496
- edear2012-02-13金牌会员41724
- 本帖最后由 edear 于 2012-2-13 00:19 编辑 *
数据库里面2张表:
t1表"
t2表
"
我的SQL语句:- SELECT a.id as a_id, b.timestamp, b.id AS b_id
- FROM t1 a
- LEFT JOIN t2 b ON ( a.id = b.t1_id )
- WHERE a.userID =3
- GROUP BY a.id
- ORDER BY b.timestamp DESC 复制代码查询结果:
"
但是我要的是t2表的第3、4行,ORDER BY b.timestamp DESC 这段不起作用,怎么解决,先谢了?