求一句SQL语句,脑子塞住了

[kanodo]

有表
Useraccounts
users
ptusers
三张
Useraccounts下有若干字段.
id,daili,userbyid
其中 daili对应users里主键ID字段
userbyid对应ptusers里主键ID字段
而users和ptusers表中,又各有name字段.
我想做到的是
一次性得出,useracounts里的id,对应users里的name,对应ptusers里的name


我知道应该是用连接就可以做的,但怎么做出做不出来,大家帮我一下

[oldmht]

select id,(select top 1 name from users where id=[useraccounts].daili) as users_name,(select top 1 name from ptusers where id=[useraccounts].userbyid) as ptusers_name from useraccounts

[kanodo]

Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'

ODBC 驱动程序不支持所需的属性。



嗯,谢谢,毛塞顿来,问题是这个问题是怎么回事啊

[oldmht]

一般是字段写错或者select写成seletc这些错误

[baby21st]

select ua.id,u.name,p.name from Useraccounts ua,users u,ptusers p
where ua.daili = u.id and ua.userbyid = p.id

[baby21st]

select ua.id as UID,u.name as un,p.name as pn from Useraccounts ua,users u,ptusers p
where ua.daili = u.id and ua.userbyid = p.id