多表查询的问题 急啊，在线等
select distinct
a.EmployeeCode , a.EmployeeName, , a.Retirement_day b.Belong2Name ,
c.Belong3Name, d.Storename
from
a ,b ,c ,d , f
where
a.EmployeeManagementID = f.EmployeeManagementID
and c.Belong3Code=f.Division
and b.Belong2Code=f.Belonging
and d.Storecode=f.Store
and a.Retirement_day= '2007-04-30 00:00:00.000 '
麻烦帮我看下这个该怎么改阿？ 其中：a.EmployeeCode , a.EmployeeName, , a.Retirement_day 这三个必须查出来，其他三个b.Belong2Name , c.Belong3Name, d.Storename
可能为空，现在这个语句出不出空的，要所有项都有数据的才能查出来，急啊
帮我看下怎莫改？
[解决办法]
select distinct
a.EmployeeCode , a.EmployeeName, , a.Retirement_day b.Belong2Name ,
c.Belong3Name, d.Storename
from
a
left join f on a.EmployeeManagementID = f.EmployeeManagementID
left join b on b.Belong2Code=f.Belonging
left join c on c.Belong3Code=f.Division
left join d on d.Storecode=f.Store
wher
and a.Retirement_day= '2007-04-30 00:00:00.000 '
[解决办法]
from
a ,b ,c ,d , f
相当于 from a inner join b on
inner join c on ...
应改成Left Join
----------------------------------
Select Distinct
a.EmployeeCode,a.EmployeeName,a.Retirement_day,b.Belong2Name,
c.Belong3Name,d.Storename
From
a
Left Join f
On a.EmployeeManagementID = f.EmployeeManagementID
Left Join c
On c.Belong3Code=f.Division
Left Join b
On b.Belong2Code=f.Belonging
Left Join d
On d.Storecode=f.Store
Where a.Retirement_day= '2007-04-30 00:00:00.000 '
