求助用了group by还想按order by ID排序

[snfqbujj1]

select xx.id,xx.tid,xx.lb,xx.uid,xx.xq,xx.img,xx.date,xx.gj,xx.lx,xx.mj,xx.zj,xx.fg,xx.hits from picture as xx,(select tid,min([px]) as zz from picture where img is not null and qu=1070 and gj=1 group by tid) as yy where xx.tid=yy.tid and xx.px=yy.zz and xx.gj=1

请教下这在哪里能搞个order by id 呀，我最终想要的是按ID的大小来排序。

[娃都会打酱油了]

select xx.id,xx.tid,xx.lb,xx.uid,xx.xq,xx.img,xx.date,xx.gj,xx.lx,xx.mj,xx.zj,xx.fg,xx.hits from picture as xx,(select tid,min([px]) as zz from picture where img is not null and qu=1070 and gj=1 group by tid) as yy where xx.tid=yy.tid and xx.px=yy.zz and xx.gj=1
order by xx.id

是这个意思？

[Dogfish]

select 
xx.id, xx.tid,
xx.lb, xx.uid, 
xx.xq, xx.img, 
xx.date, xx.gj, 
xx.lx, xx.mj, 
xx.zj, xx.fg, 
xx.hits 
from picture as xx,
(select tid,min([px]) as zz from picture where img is not null and qu=1070 and gj=1 group by tid) as yy 
where xx.tid=yy.tid and xx.px=yy.zz and xx.gj=1
order by xx.id

[snfqbujj1]

多谢楼上两位，的确可以，因为查询条件有点多，我链接的时候写错了，所以没执行。看了两位写的我仔细检查了粗心了。现在已经好了。