trying to structure sql to merge two datasets. structure follows: dbs.possible.combos (all possible combinations of dates and places) Date Place 1/1/10 N-01 1/1/10 S-02 1/2/10 N-01 1/2/10 S-02 etc...
dbs.aggregate (the raw data aggregated by date and location) Date Place Days 1/1/10 N-01 6 1/1/10 S-02 10 1/2/10 S-02 5 Trying to merge so I look-up the values for each possible combo dbs.final <- sqldf("select dbs.possible.combos$Date, dbs.possible.combos$Place, dbs.possible.combos$Days FROM dbs.possible.combos LEFT JOIN dbs.aggregate ON (dbs.possible.combos$Place = dbs.aggregate$Place) AND (dbs.possible.combos$Date = dbs.aggregate$Date)") Resulting in: Error in sqliteExecStatement(con, statement, bind.data) : RS-DBI driver: (error in statement: near ".": syntax error) What am I getting wrong in the syntax? -- View this message in context: http://n4.nabble.com/question-on-sqldf-syntax-tp1289707p1289707.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.