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

Question

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 says:

there is a syntax error near "FROM"

What am I doing incorrectly here?

@Pheonixblade9 How are those answers different from my t-sql — pthalacker, Apr 30 '15 at 01:41
[SQLite doesn't support JOINs in UPDATE statements](http://sqlite.org/lang%5Fupdate.html), Use [IN statement](http://stackoverflow.com/a/774300/4519059) ;). — shA.t, Apr 30 '15 at 06:44

Vasily Ivoyzha · Answer 1 · 2015-04-30T02:59:38.180

-1

you need to replace Source by [Source]

edited Apr 30 '15 at 02:59

answered Apr 29 '15 at 23:55

Vasily Ivoyzha

score -1 · Answer 2 · answered Apr 29 '15 at 23:56

-1

Source is a keyword in SQL used for MERGE JOINs.

Put brackets around it to force it to be used as a string literal:

UPDATE p 
SET SourceId = s.Id 
FROM Practice p 
INNER JOIN [Source] s 
ON p.[Source] = s.[Name]

answered Apr 29 '15 at 23:56

Codeman

No joy. Error remains. But good info that I did not know – pthalacker Apr 30 '15 at 01:20

2 Answers2