Declare @LergData table(lata varchar(4),ocn varchar(4),npa varchar(3),nxx varchar(3),y varchar(2),TBPI varchar(1))
insert into @LergData select '224','4804',201,204,0,'Y'
insert into @LergData select '224','8700',201,204,1,'Y'
insert into @LergData select '224','6664',201,204,2,'Y'
insert into @LergData select '224','325E',201,204,3,'Y'
insert into @LergData select '224','6664',201,204,6,'Y'
insert into @LergData select '224','6664',201,204,7,'Y'
insert into @LergData select '224','6623',201,204,8,'Y'
insert into @LergData select '224','4804',201,204,9,'Y'
insert into @LergData select '224','389C',201,204,'A','Y'
insert into @LergData select '224','6391',201,207,'A','N'


Declare @OCN Table (lata varchar(4),ocn varchar(4),inter decimal(18, 7),intra decimal(18, 7))
insert into @OCN select '224','325E',0.0167,0.0167
insert into @OCN select '224','389C',0.0165,0.0165
insert into @OCN select '224','4804',0.0155,0.0155
insert into @OCN select '224','6623',0.0145,0.0145
insert into @OCN select '224','6664',0.0167,0.0167
insert into @OCN select '224','8700',0.0165,0.0165
insert into @OCN select '224','6391',0.0135,0.0135



SELECT c.NPANXX,o.inter,o.intra

FROM @OCN AS o
INNER JOIN

(SELECT DISTINCT b.NPANXX,b.lata,b.ocn

FROM @LergData AS a
INNER JOIN 

(SELECT CASE 
			WHEN TBPI = 'Y' AND y = 'A' THEN NULL
			WHEN TBPI = 'Y' THEN npa+''+nxx+''+y 
			ELSE npa+''+nxx
	   END AS NPANXX,lata,ocn
FROM @LergData b
Group by npa+''+nxx,npa+''+nxx+''+y,y,TBPI,lata,ocn) b 

ON a.npa+''+a.nxx = LEFT(b.NPANXX,6)) c
ON c.lata = o.lata AND c.ocn = o.ocn

ORDER BY NPANXX