This is the result after Update

CVID point_To_Scorescore

72 10 10

76 10 10

77 10 NULL

78 10 NULL

79 10 NULL

88 10 10

90 10 NULL

92 10 NULL

93 10 NULL

97 10 NULL

This is the explanation. See x_ApplyJob

1- CVID=72 have JobNoticeID that EXISTS in z_JobChecking. It's 22. One or more record EXISTS is enough

2- CVID=76 have JobNoticeID that EXISTS in z_JobChecking. It's 45. One or more record EXISTS is enough

3- CVID=88 have JobNoticeID that EXISTS in z_JobChecking. It's 45. One or more record EXISTS is enough

4- CVID=90 do not have JobNoticeID that EXISTS in z_JobChecking. So, no score for this row