Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem While Writing Query

user11688398Jun 4 2013 — edited Jun 4 2013
Hi:

There are three tables,

*1.TbReg*
reg_no,reg_name

Data:
RO1 Reg1
RO2 Reg2
RO3 Reg3

*2.TbZbr*
br_no,reg_no

Data:
092 RO1
013 RO1
020 RO3


*3.TbLM_Mast*
LM_no,br_no

Data:

1 013
2 013
3 020

Required O/p:

Reg_name | NoOfLeads |

RO1 | 2 |
RO2 | 0 |
RO3 | 1 |

From Above tables i want to write query for,

select total number of leads available in TbLM_Mast against each branch(*br_no*) from TbZbr,
and compare same reg_no with TbReg table and display required O/p/


So, how to write this query...?

Can any body help me...

Thank You,
Anup Desai
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2013
Added on Jun 4 2013
6 comments
89 views