"Darryl Hebbes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I am getting a syntax error like this : > > near ".": syntax error > > when I run the following code. > > > UPDATE site_profile > SET site_profile.title = (select site_profiletemp.title from
Make it SET title = (select site_profiletemp.title from The SET clause of UPDATE statement requires a plain unqualified column name. > site_profiletemp where site_profile.title = site_profiletemp.title), > site_profile.title = (select site_profiletemp.title from > site_profiletemp where site_profile.title = site_profiletemp.title) You have the exact same assignment twice. Drop one of them. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users