On Tue, Oct 14, 2014 at 8:10 PM, Shantanu Namjoshi < shantanu.namjo...@business.uconn.edu> wrote:
> > UPDATE dailydelete > SET SMB = (SELECT dailyfactors.SMB FROM dailyfactors WHERE > dailydelete.data = dailyfactors.Date), > SET Rf = (SELECT dailyfactors.Rf FROM dailyfactors WHERE dailydelete.data > = dailyfactors.Date) > > WHERE EXISTS (select * from dailyfactors WHERE dailydelete.data = > dailyfactors.Date); > > > I get the following error: > Error: near "SET": syntax error > On the syntax diagram (http://www.sqlite.org/lang_update.html) the SET keyword only occurs once. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users