Subject Re: outer joins
Author Ed Dressel
> select
> blah....,
> CO.CompanyName,
> blah...
> from ActionLog AL
> left join ClientInfo CI
> on CI.Client_ID = AL.Client_ID /* nulls in client fields if no
match */
> left join CompanyInfo CO
> on CI.Company_ID = CO.Company_ID /* nulls in company fields if
no match */
> where AL.Action_DateTime > '02-AUG-2004' <-- note you must use the
> in the search clause (and also in group by and order by clauses, if

that gives me exactly what I wanted--and is what I thought I was
doing in the first place (before I posted here). Thanks for your time.

Ed Dressel