update vs4tflight Set TFLiEmpCodeList=(select TFlECode FROM VS4TFlightEmployee WHERE vs4tflight.TFliNo=VS4TFlightEmployee.TFlETFliNo and VS4TFlightEmployee.TFlELn=1) where TFLiEmpCodeList='' or TFLiEmpCodeList is null
GO
update vs4tflight Set TFLiEmpNameList=(select TFlEName FROM VS4TFlightEmployee WHERE vs4tflight.TFliNo=VS4TFlightEmployee.TFlETFliNo and VS4TFlightEmployee.TFlELn=1) where TFLiEmpNameList='' or TFLiEmpNameList is null
GO
update vs4tflight Set TFLiGuildCodeList=(select TFlGCode FROM VS4TFlightGuide WHERE vs4tflight.TFliNo=VS4TFlightGuide.TFlGTFliNo and VS4TFlightGuide.TFlGLn=1) where TFLiGuildCodeList='' or TFLiGuildCodeList is null
GO
update vs4tflight Set TFLiGuildNameList=(select TFlGName FROM VS4TFlightGuide WHERE vs4tflight.TFliNo=VS4TFlightGuide.TFlGTFliNo and VS4TFlightGuide.TFlGLn=1) where TFLiGuildNameList='' or TFLiGuildNameList is null
GO
update vs4tflight Set TFLiLicenseNoList=(select TFVhType+' '+TFVhLicenseNo FROM VS4TFlightVehicle WHERE vs4tflight.TFliNo=VS4TFlightVehicle.TFVhTFliNo and VS4TFlightVehicle.TFVHLn=1) where TFLiLicenseNoList='' or TFLiLicenseNoList is null
GO