关于sqldf package 问题请教

luolian

语句tmp2 = sqldf("select tmp2.*,sum(a.total_cost) as sum_cost, sum(a.outcome) as dead from 'tmp2', 'aki.adm.uniq' as a where a.uniq_id=tmp2.uniq_id and a.date_in>=tmp2.date_in and a.date_out<= tmp2.date_out group by tmp2.uniq_id, tmp2.date_in")错误提示：Error in sqliteSendQuery(con, statement, bind.data) : error in statement: no such column: a.total_cost
求高手指点

englianhu

数据的问题吧？查看一下楼主的数据？{:soso_e127:}
https://cran.r-project.org/web/packages/sqldf/sqldf.pdf