> 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

aliases

> in the search clause (and also in group by and order by clauses, if

present)

>

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