Hi,

it's working i have just added

t1.cat= t2.cat

select t1.part, t1.cat, isnull(t2.qty ,0) qty

from @t1 t1

left join @t2 t2

on t1.part = t2.part

or t1.cat= t2.cat

Thank you very much

Vinay

Come on guys

Is this possible?

Is there any one can solve this.

Please help me.

Regards

Vinay