Hi!!

I want to find the count of records from two tables corresponding to each record in the third table
Here is what i mean:

Table1
pk_id1 varchar2(10)

Table2
pk_id2 varchar2(10)
pk_id1 varchar2(10)

Table3
pk_id3 varchar2(10)
pk_id1 varchar2(10)

Table2 and Table3 has foreign key refering
the pk_id1 of table 1
Table2 and Table3 can have many records corresponding
to single pk_id1 of Table 1

I tried this query:

Select
count(a.pk_id3) cnt_table3,
count(b.pk_id2) cnt_table2,
a.pk_id1
from table3 a, table2 b, table1 c
Where c.pk_id1 = b.pk_id1
and c.pk_id1 = c.pk_id1
Group by c.pk_id1

But his doesn't seems to work. Please help!!

Thanks

Regards
Shruti