mercredi 29 avril 2015

Why am I getting an error executing this statement in DB Browser for Sqlite?

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