UPDATE ITEMS
SET ID_SECTION = (
SELECT B.ID_SECTION
FROM TT_ItemSection B
WHERE ITEMS.ID_ITEM = B.ID_ITEM AND B.IS_MAINSECTION = ‘Y’
);
how can i fasten this query. It is taking so much to execute (SQLITE)
I tried update from with joins but it doesnt work in sqlite
New contributor