大家帮忙看看这个SQL语句怎么写？

[byebye8742]

要用另外一个搜索条件作为排序的字段，我随便写一个肯定不对的，大家改正一下：
select * from article order by (select ontime from article where id=前面一个select里面的id)
我说明一下为什么要这么做，是因为一个论坛回复的帖子和发表的帖子都是放在一个表中的，唯一的区别就是如果是帖子的话fatherarticleid=0,是回复的话fatherarticleid=帖子的id,如果我要按照回复排序是不是就要让排序的字段是回复(where fatherarticleid=帖子的id)的time,究竟怎么做呢？
如果不能在一局sql语句里面表达清楚，大家想象其他办法

[book523]

select a.* from table1 a,table2 b where
a.id=b.id order by b.ontime

[cpp2017]

select * from arcticle AS A order by (select ontime from arctive where id=A.id)

[xiwanghope]

同意上面的做法～

[byebye8742]

还是不队，大家看看有什么错误
exec="select *from article AS A where fatherarticleid=-1 order by (select ontime from article AS B where A.articleid=B.fatherarticleid)"

[byebye8742]

好人作到第啊，大家再看看

[czp98069806]

你那个根本上行不通的

[yonghengdizhen]

select a.*,b.* from article a join article b on a.id=b.fatherarticleid and a.fatherarticleid=0 order by a.ontime,b.ontime

看你的目的是为了按原贴和回贴时间进行排序

[byebye8742]

正确的怎么写呢？

[byebye8742]

exec="select *from article AS A where fatherarticleid=-1 order by (select ontime from article AS B where A.articleid=B.fatherarticleid)"
是这句话的意思
是按照回复的ontime排序而回复就是articleid=fatherticleid

[yonghengdizhen]

select a.*,b.* from article a join article b on a.id=b.fatherarticleid and a.fatherarticleid=0 order by b.ontime