可怪问题发！！

[a97191]

select kid,content,fname=(select fname from fmnu where fid=five.fid),sname=(select sname from smnu where sid=five.sid),tname=(select tname from tmnu where tid=five.tid),wname=(select wname from four where wid=five.wid) from five
在sql2000可以执行并得到结果，在access2000不可以

[OracleRoob]

SQL Server使用的是Transact-SQL，而Access用的是Jet-SQL。当然不行了。

[OracleRoob]

--try

select
kid,
content,
(select fname from fmnu where fid=five.fid) as fname,
(select sname from smnu where sid=five.sid) as sname,
(select tname from tmnu where tid=five.tid) as tname,
(select wname from four where wid=five.wid) as wname
from five