Luis: It works, However I changed the data somewhat slightly. Now we have 2 more rows in table @a that do not have members in @B.

Take a look at the output listed below. Need your help please.

-----------------------------------------------------------------------------

Declare @a table ( p_code varchar(100), CNT INT );

insert INTO @a( p_code, CNT ) VALUES ( '1', 100 );

insert INTO @a( p_code, CNT ) VALUES ( '2', 200 );

insert INTO @a( p_code, CNT ) VALUES ( '3', 250 );

insert INTO @a( p_code, CNT ) VALUES ( '4', 600 );

Declare @b-2 table ( p_code varchar(100), name varchar(100), CNT INT );

insert INTO @b-2( p_code, name, CNT ) VALUES ( '1', 'John' , 25 );

insert INTO @b-2( p_code, name, CNT ) VALUES ( '1', 'Peter' , 25 );

insert INTO @b-2( p_code, name, CNT ) VALUES ( '1', 'Max' , 25 );

insert INTO @b-2( p_code, name, CNT ) VALUES ( '1', 'Ray' , 25 );

insert INTO @b-2( p_code, name, CNT ) VALUES ( '2', 'SAN' , 25 );

insert INTO @b-2( p_code, name, CNT ) VALUES ( '2', 'DEY' , 50 );

insert INTO @b-2( p_code, name, CNT ) VALUES ( '2', 'PITS' , 50 );

insert INTO @b-2( p_code, name, CNT ) VALUES ( '2', 'DET' , 75 );

/*

p_code namecnt

1 100

1 John 25

1 Peter 25

1 Max 25

1 Ray 25

2200

2SAN 25

2DEY 50

2PITS 50

2DET 75

3250

4600

*/