Hi Pavel, On Thu, Jun 11, 2009 at 8:28 PM, Pavel Ivanov<[email protected]> wrote: > According to this http://www.sqlite.org/lang_update.html you have > invalid syntax. > I believe you can achieve the same by this (assuming that id is unique > in fud28_thread): > > UPDATE fud28_read > SET user_id=2, last_view=1244710953, > msg_id=(SELECT last_post_id FROM fud28_thread > WHERE id = fud28_read.thread_id) > WHERE user_id=2 > AND thread_id in (SELECT id FROM fud28_thread > WHERE forum_id=4 AND last_post_date > 0)
Thanks for the quick reply. The thread id is unique and your solution works like a charm. BTW: Are there any plans to support the original syntax at some stage (it's working with MySQL, PostgreSQL and Oracle)? Best regards. Frank _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
