SQLite UPDATE

DaveS · October 17, 2015, 5:29pm

I guess I’m brain-dead, since I write SQL every day…

UPDATE myTable a SET ID=(SELECT id FROM theirTable b WHERE a.criteria=b.criteria)

Eli_Ott · October 17, 2015, 5:34pm

UPDATE myTable AS a ...

DaveS · October 17, 2015, 5:40pm

Nope… gives

THIS fixed it, but not sure why I can’t use an Alias

UPDATE myTable SET ID=(SELECT id FROM theirTable b WHERE myTable.criteria=b.criteria)

Norman_P · October 17, 2015, 11:06pm

sqlite doesnt support table aliases on update statements