Left Join causes invalid operation

[Guest]

Can anyone tell my why the following Query causes an Invalid operation? If I
change it to and Inner or Right Join it works fine.

SELECT TotalProdDP.Policy, TotalProdDP.Face, Directory_Corporate.[Division
Name], Directory_Corporate.[Business Unit Name], Directory_Corporate.[Market
Name], Directory_Corporate.Location, TotalProdDP.TransferDate
FROM Directory_Corporate LEFT JOIN TotalProdDP ON
Directory_Corporate.Location = TotalProdDP.SCILocation;

 

[Marshall Barton]

Can anyone tell my why the following Query causes an Invalid operation? If I
change it to and Inner or Right Join it works fine.

SELECT TotalProdDP.Policy, TotalProdDP.Face, Directory_Corporate.[Division
Name], Directory_Corporate.[Business Unit Name], Directory_Corporate.[Market
Name], Directory_Corporate.Location, TotalProdDP.TransferDate
FROM Directory_Corporate LEFT JOIN TotalProdDP ON
Directory_Corporate.Location = TotalProdDP.SCILocation;

I think the error is in yout code (or somewhere?) that uses
the Policy or Face field. The problem can be caused by a
function or expression that does not allow for a value being
Null. The fields from TotalProdDP will be Null when there
are no records that match the Location field.