[R] question on sqldf syntax

[lith]

On 25 Jan., 20:26, GL <pfl... at shands.ufl.edu> wrote:
> Actually, better sql would likely be:
>
> dbs.final <- sqldf("select * from dbs.possible.combos left join
> dbs.aggregate using (Date,Place)")
>
> but this still doesn't work

I'd suspect name mangling to cause the problem:
http://code.google.com/p/sqldf/#2._Why_does_sqldf_seem_to_mangle_certain_variable_names?

Try to quote the table names with backticks (`).