• 本帖最后由 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 这段不起作用,怎么解决,先谢了?