> Still, maybe you really are trying to count rows for some useful

purpose....

actually I put count(*) in for this ng for simplicity reasons :-)

In the actual data, I want every record from ActionLog, and

1) the client's name from ClientInfo (if the client exists, Client_ID
in ActionLog can be mull)
2) and when there is a Client (i.e. the Client_ID from ActionLog is
not null) the Client's Company's Name from CompanyInfo)

Is that possible?

Thanks
Ed Dressel