I have the error msg above when I run the query statement like this.
I can understand that the inner member of an outer-join may have NULL
as value, which may cause error in the equal join.

select a.* From entity a,
(select b.cl_co_id from company_location b, location_role c where b.coloc_id
= c.lr_loc_id) dd
where a.co_id *=dd.cl_co_id

===========================================
But if I do the equal join first, like in my above SQL statement,
then do the outerjoin, why is this not acceptable? Does the SQL interpretter
has executing order built into it? I am using Microsoft SQL Server 2000.
So is building a temporary table to hold the equal join result is the only
solution here?

Thanks
Pat