• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

Help with update query

Please take a look at the attached SQL query. I need to update MASTER6.SSN = secaccessmerge.SSN where L__d__bName matches in both tables AND where MASTER6.Desired__bAction = "Physician'

Do I have the syntax correct? Thanks in advance.
UPDATE MASTER6 INNER JOIN secaccessmerge ON MASTER6.L__d__bName=secaccessmerge.L__d__bName AND MASTER6.Desired__bAction = 'Physician' SET MASTER6.SSN=secaccessmerge.SSN

Open in new window

0
isaacr25
Asked:
isaacr25
1 Solution
 
BrandonGalderisiCommented:
Close...

UPDATE  m
SET SSN=s.SSN
from MASTER6  m
INNER JOIN secaccessmerge  s
  ON m.L__d__bName=s.L__d__bName
  AND m.Desired__bAction = 'Physician'

0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now