select id,title,replycount
from
(SELECT requests.id, requests.title,(select count(*) from requests a where a.parent_id=requests.id) AS replycount FROM requests
) tableA
order by replycount
from
(SELECT requests.id, requests.title,(select count(*) from requests a where a.parent_id=requests.id) AS replycount FROM requests
) tableA
order by replycount
order by replycount --这是对的
我在access直接写order by replycount是不行的!