oracle sql - case statement and count

[Avi Sridhar]

Hi All friendly people

I have 2 tables table1 and table2

table 1 and table 2 have got ids.

my condition is ,

if table1.id=table2.id then i will need the count on the table2 ids, else if table1.id is not present in table2.id then for the table1.id the count should be 0.

This is what i have done so far.

   
select table1.id,       
(
COUNT(
CASE
when table1.id = table2.referer_id 
--WHEN did_date = 1
THEN table2.referer_id
ELSE 0
END
)
) AS count

 

I am not able to figure it out. Please help.


Thanks,

[Jeanne Boyarsky]

What happens when you run the code you posted - error message, unexpected result, etc?