Hi Guys

I think I mixed two requiements in 1 query.

I will re-iterate my problem.Pls ignore the above ddl:

The basic scenario for this report is:

MASTER table has a list of...

Yes that should be fine. Thanks

Here it is

create table #Something

(

Line_no int,

code varchar(5),

AccountNo char(5)

)

insert #Something

select 12311, 'P1c', 'Ac115' union all

select 12311, 'L1', 'Ac115' union all

select 123, 'C1', 'Ac115' union all

select 1222, 'C1', 'Ac115' union all

select 1243,...

Hi

Thanks for the code.

You are right.

I have multiple lines of same parent code in my database.

How do I deal with that? ?

Pls help !!!

Hi Jeff

Here is what I want:

create table #Something

(

Line_no int,

code varchar(5),

AccountNo char(5)

)

insert #Something

select 12311, 'P1c', 'Ac115' union all

select 12311, 'L1', 'Ac115' union all

select 123, ...

Yes it does match what I want as output.

However the trouble is, these child codes are common codes for various other parent codes.

For example two different parents can share the...

Hi Sean

The child account does not have a link code. It only has the child code.

so if I use this query for the whole dataset by just filtering on child...

Hi Alan

In your query you have not taken into account the code for child

I have a big dataset where we have multiple combination of parent and child codes

thanks

Thanks for this.

I am working in pl/sql and it says 'LEFT' as an invalid identifier

Hi

Apologies for not following the format. I will keep this in mind next time.

My desired output is

Parent_Count | Child_count

2 ...