|
|
语句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
求高手指点
|
|
发表于 2015-1-13 14:49:12