mssql的查询语句换成access怎么写
select F.ForumId,F.IsSelected,F.ForumName,F.ForumUrl,F.ForumPr,F.ForumBr,F.ForumNote,(select count(1) from Board where ForumId=F.ForumId) as BrardNumber ,(select count(1) from User where ForumId=F.ForumId) as UserNumber from Forum F order by ForumId
原本是mssql的数据库，现在我要用access数据库，但是同样的语句报错：语法错误，我对access的查询语句不熟，求正确的写法。
select F.ForumId,F.IsSelected,F.ForumName,F.ForumUrl,F.ForumPr,F.ForumBr,F.ForumNote,
(select count(1) from Board where ForumId=F.ForumId) as BrardNumber ,
(select count(1) from [User] where ForumId=F.ForumId) as UserNumber
from Forum F
order by ForumId