为什么 这个语句会出错?

[da18a]

select top 1 *,(select count(*) from mf_post where (threadid = Aa.threadid)) as threadpostcount from mf_thread Aa inner join mf_user Bb on Aa.userid = Bb.userid where (forumid = 1) and (threadid not in (select top 0 threadid form mf_thread where (forumid = 1))) order by threadid desc

[skyboy0720]

select top 1 *,
(select count(*) from mf_post where (threadid = Aa.threadid))
as threadpostcount from mf_thread Aa inner join mf_user Bb
on Aa.userid = Bb.userid where (forumid = 1) and
(threadid not in (select top 0 threadid from mf_thread
where (forumid = 1))) order by threadid desc

[skyboy0720]

form mf_thread
----->
from mf_thread

[chinaandys]

//....(forumid = 1) and (AS.threadid not in (select threadid form mf_thread where (forumid = 1)))

fornumid、threadid 列是 Aa表还是Bb
(Aa.fornumid=1)and (Aa.threadid<>1)
order by Aa.threadid desc

[da18a]

form mf_thread
----->
from mf_thread

晕哦