This should work
select C.cId cc, count(D.catId) dd from C
left outer join D on C.cId = D.catId
group by cc;
- michael dykman
- [EMAIL PROTECTED]
Kapoor, Nishikant wrote:
Hello List,
It sounds like a simple query but I have spent quite a few hours already, and still do
not have a
Hello List,
It sounds like a simple query but I have spent quite a few hours already, and still do
not have a solution. Would greatly appreciate your response.
Here is what I am trying to do:
---
create table C (cId tinyint(4) NOT NULL);
insert into C values (1),
Hi,
It sounds like a simple query but I have spent quite a few hours already,
and still do not have a solution. Would greatly appreciate your response.
Here is what I am trying to do:
---
create table C (cId tinyint(4) NOT NULL);
insert into C values (1), (2),