update vs4tsopassenger set tVSPFirstname=(select tar3firstname2 from vs4tar3 where vs4tar3.tar3tarncode=vs4tsopassenger.tvsptarncode) where vs4tsopassenger.tVSPFirstname ='' or vs4tsopassenger.tVSPFirstname is null
GO
update vs4tsopassenger set tVSPlastname=(select tar3lastname2 from vs4tar3 where vs4tar3.tar3tarncode=vs4tsopassenger.tvsptarncode) where vs4tsopassenger.tVSPlastname ='' or vs4tsopassenger.tVSPlastname is null
GO
update vs4tsopassenger set tVSPtitlename=(select tar3titlename2 from vs4tar3 where vs4tar3.tar3tarncode=vs4tsopassenger.tvsptarncode) where vs4tsopassenger.tVSPtitlename ='' or vs4tsopassenger.tVSPtitlename is null
GO