帮我改下面的代码连接为左连接

Question

select ClientID,CarID,SaleID,RepairID,OwnerName,IdentityCard,IsMale,BirthDate,ClientProperty=ClientProperty.Name,
Occupation=Occupation.Name,WorkCompany,OwnerTel,LinkmanName,LinkmanTel,LinkmanMobile,LinkmanName2,LinkmanTel2,
RegionID=Region.Name,CountyID=County.Name,Town,Address,PostalCode,ClientManagerID=Employee.EmployeeName,
RegisterDate,OperatorID=Employee.EmployeeName,IsFromFutureClient 
into TrueTableClient
from Client ,Region,County,Employee
Left join ClientProperty on  Client.ClientProperty=ClientProperty.ClientPropertyID 
Left join Occupation on  Client.Occupation=Occupation.OccupationID
Left Join Region on Client.RegionID=Region.RegionID 
Left join County on Client.CountyID=County.CountyID 
Left join Employee on Client.ClientManagerID=Employee.EmployeeID and Client.OperatorID=Employee.EmployeeID

Answer 1

select ClientID,CarID,SaleID,RepairID,OwnerName,IdentityCard,IsMale,BirthDate,ClientProperty=ClientProperty.Name,
Occupation=Occupation.Name,WorkCompany,OwnerTel,LinkmanName,LinkmanTel,LinkmanMobile,LinkmanName2,LinkmanTel2,
RegionID=Region.Name,CountyID=County.Name,Town,Address,PostalCode,ClientManagerID=Employee.EmployeeName,
RegisterDate,OperatorID=Employee.EmployeeName,IsFromFutureClient into TrueTableClient
from Client left join ClientProperty on Client.ClientProperty=ClientProperty.ClientPropertyID
left join Occupation on Client.Occupation=Occupation.OccupationID
left join Region on Client.RegionID=Region.RegionID 
left join County on Client.CountyID=County.CountyID
left join Employee on Client.ClientManagerID=Employee.EmployeeID and Client.OperatorID=Employee.EmployeeID

Answer 2

select ClientID,CarID,SaleID,RepairID,OwnerName,IdentityCard,IsMale,BirthDate,ClientProperty=ClientProperty.Name,Occupation=Occupation.Name,WorkCompany,OwnerTel,LinkmanName,LinkmanTel,LinkmanMobile,LinkmanName2,LinkmanTel2,RegionID=Region.Name,CountyID=County.Name,Town,Address,PostalCode,ClientManagerID=Employee.EmployeeName,RegisterDate,OperatorID=Employee.EmployeeName,IsFromFutureClient into TrueTableClient from Client left join ClientProperty on Client.ClientProperty=ClientProperty.ClientPropertyID left join Occupation on Client.Occupation=Occupation.OccupationID left join Region on Client.RegionID=Region.RegionID left join County on Client.CountyID=County.CountyID left join Employee on Client.ClientManagerID=Employee.EmployeeID and Client.OperatorID=Employee.EmployeeID

Answer 3

select ClientID,CarID,SaleID,RepairID,OwnerName,IdentityCard,IsMale,BirthDate,ClientProperty=ClientProperty.Name,
Occupation=Occupation.Name,WorkCompany,OwnerTel,LinkmanName,LinkmanTel,LinkmanMobile,LinkmanName2,LinkmanTel2,
RegionID=Region.Name,CountyID=County.Name,Town,Address,PostalCode,ClientManagerID=Employee.EmployeeName,
RegisterDate,OperatorID=Employee.EmployeeName,IsFromFutureClient 
into TrueTableClient
from Client
Left join ClientProperty on  Client.ClientProperty=ClientProperty.ClientPropertyID 
Left join Occupation on  Client.Occupation=Occupation.OccupationID
Left Join Region on Client.RegionID=Region.RegionID 
Left join County on Client.CountyID=County.CountyID 
Left join Employee on Client.ClientManagerID=Employee.EmployeeID and Client.OperatorID=Employee.EmployeeID

Answer 4

不过改为左连接后与原查询的结果就不一样了。
如要一样，将 Left join 改为 join 就行了。