statement is quite limited - it doesn't support joining to other tables, for example.
SQL As Understood By SQLite | UPDATE
As a result, there's no ambiguity as to which table the updated column belongs to, so it doesn't support prefixing the column names in the
list with the table name.
The correct query is:
Genre = (SELECT Genre from config.Genres WHERE Main.Genres.Id = config.Genres.Id)
(NB: Just using
as the column name in the
list, rather than