I have 3 tables

ActionLog
ClientInfo (Client_ID)
CompanyInfo (Company_ID)


where ClientInfo is an outer join on ActionLog (got that working
fine) but CompanyInfo needs to have an outer join on ClientInfo--
which I can't get the to work. (I understand why it doesn't work,
just not what to do to get it to work).

My SQL is:

select count(*)
from ClientInfo CI right outer join ActionLog AL on CI.Client_ID =
AL.Client_ID, CompanyInfo CO right outer join Clientinfo CI2 on
CO.Company_ID = CI2.Company_ID

How should I change it?

Thanks
Ed Dressel