On Tue, Oct 14, 2014 at 8:10 PM, Shantanu Namjoshi < [email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
