Displaying 1 result from an estimated 1 matches for "lang_upd".
Did you mean:
lang_id
2010 Aug 26
1
sqldf syntax
Please correct the following
> sqldf("update esc left join forwagg on esc.ym=forwagg.Date set esc.ri2=forwagg.N1 where esc.age=12","select * from main.esc")
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: near "left": syntax error)
Thanks.
Stephen
[[alternative HTML version deleted]]