update GA_SA
set GA_SA.FPRICE=CA_MAS.FPRICE
where GA_SA.FPRICE is null and GA_SA.NO =(
select * from CA_MAS where CA_MAS.NO=GA_SA.NO
)
set GA_SA.FPRICE=CA_MAS.FPRICE
where GA_SA.FPRICE is null and GA_SA.NO =(
select * from CA_MAS where CA_MAS.NO=GA_SA.NO
)
set GA_SA.PRICE = CA_MAS.PRICE
inner join CA_MAS ON
CA_MAS.NO=GA_SA.NO
WHERE GA_SA.PRICE is null
Update B set B.FPRICE=A.FPRICE
from CA_MAS A,GA_SA B
where A.NO=B.No and B.FPRICE is null
set GA_SA.FPRICE=CA_MAS.FPRICE
from GA_SA,CA_MAS
where GA_SA.FPRICE is null and GA_SA.NO=CA_MAS.NO