create table #customer (
ID int NOT NULL ,
VS int NOT NULL 
)

create table #Customerview (
ID int NOT NULL ,
Tname nchar (10) NOT NULL ,
FN nchar (3) NOT NULL,
PV int NOT NULL,
status nchar (2)
)


insert #Customer 
select 1, 2 union all
select 2, 1


insert #Customerview
select 1, 'PERSONAL','VT',3,'Y' union all
select 2, 'PERSONAL','VT',4,'Z' 

update #Customerview
set PV = #Customer.VS
from #Customerview
inner join #Customer on #Customerview.ID = #Customer.ID
where #Customerview.PV <> #Customer.VS and #Customerview.status = 'Y'

Select * from #Customerview