Hi Guys Need help on a small query :
I have a table A which has large number of run_id, and each run _id is mapped to other table B with multiple result_id. that is for one run_id I have multiple results_ids. And each result _id row has a nested table C which has multiple number of rows. What I need is to map run_id with result_id and for each result_id I need a count rows of nested table C.
I tried with a simple one select count(C) from B, table C where B.result_id=####, this runs fine on sigle instance. but the same is not working fine for multiple instances of result_id and further when mapped to table A run_id.
Thanks in advance for your assistance.