多表连接的SQL语句问题!!!!!!!!!!!!!!!!!!!!????????????????

[autocar]

多表连接的SQL语句问题!!!!!!!!!!!!!!!!!!!!????????????????

我想将employee和gslegal 表合并到gsmaster的记录一齐显示,合并的依据是clientid 字段


语句如下:

select a.* from (select
gsmaster.clientname,gsmaster.contactaddre,employee.employename,employee.employesex,gslegal.legalname


from employee left outer join gsmaster on gsmaster.clientid =employee.clientid ,

gslegal left outer join gsmaster on gsmaster.clientid =gslegal.clientid

) as a


但执行时出错,数据库是sql server 2000,


请各位指教,谢谢!!

[jiandanyu]

select
gsmaster.clientname,gsmaster.contactaddre,employee.employename,employee.employesex,gslegal.legalname


from employee left outer join gsmaster on gsmaster.clientid =employee.clientid left outer join gslegal on gsmaster.clientid =gslegal.clientid

[mygoldbaby]

你想从3个表里取记录，对吗？
这样：
select employee.*,gsmaster.*,gslegal.* from employee,gsmaster,gslegal
where employee.clientid=gsmaster.clientid and gsmaster.clientid=gslegal.clientid

你可以根据需要，只SELECT 某写字段。
很灵的。