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