Hi, I need some help getting this UPDATE to work with sqlite 3.3.8:
UPDATE fud28_read SET user_id=2, msg_id=t.last_post_id, last_view=1244710953 FROM (SELECT id, last_post_id FROM fud28_thread WHERE forum_id=4 AND last_post_date > 0) t WHERE user_id=2 AND thread_id=t.id Error: near "FROM" - syntax error: HY000 Does sqlite support inline views/ derived tables within UPDATE statements? Any suggestions on how to get it to work? Best regards. Frank _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users