Hi for the code given,

select (case when ((a.SourceSegment= b.Segment)or(a.SourceTerritory= b.Territory)) then b.Terr_ID else '' end),

(case when ((a.TargetSegment = c.Segment) or (a.TargetTerritory = c.Territory)) then c.Terr_ID else '' end)

from...

wow i just came up with the same code as urs!!! 😀

Thankfully i cud do something rite finally :hehe: thanks a ton!!!

Thanks a lot Arun,

But i just got an info that the data enterted into Ter_Ter_Alignment need not have data in both source segment and source territory or target segment and...