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 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) WHERE EXISTS (select * from site_profiletemp where site_profile.title = site_profiletemp.title); I want to update one table with data from another. Many Thanks Darryl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
