Update VS4TTaxTrans Set TTxTClientCitizen=(SELECT TEmpCitizenNo From VS4Temployee WHERE VS4Temployee.tempcode=VS4TTaxTrans.TTxTClientCode)
WHERE (TTxTClientCitizen='' or TTxTClientCitizen is null) and TTxTType=4
GO