多表连接的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,
请各位指教,谢谢!!
语句如下: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,
请各位指教,谢谢!!
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
这样:
select employee.*,gsmaster.*,gslegal.* from employee,gsmaster,gslegal
where employee.clientid=gsmaster.clientid and gsmaster.clientid=gslegal.clientid你可以根据需要,只SELECT 某写字段。
很灵的。