I am trying to execute this statement in DB Browser
UPDATE p SET SourceId = s.Id
FROM Practice p INNER JOIN Source s ON p.Source = s.Name
and it is refusing to execute complaining that there is a syntax error near "FROM"
What am I doing incorrectly here?
Aucun commentaire:
Enregistrer un commentaire