Ability to Report Leads with no Onwer

Hi

I have been attempting to list out all Leads that do not have an owner (lead owner is null), however when I do this it returns no values (I know there are rows where this is the case).

It appears as if when I refer to the Lead Owner it does an inner join to the User table and therefore implicitly excludes all records where Lead Owner is null, hence the empty return set.

Am I doing something wrong, is there any switch to set a left join or include null value rows?

Thanks,

James Salt

Moreton Solutions

Specialist in Construction Software