|Subject||Re: outer joins|
> Still, maybe you really are trying to count rows for some usefulpurpose....
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?