Re: [R] question on sqldf syntax

[lith]

On 25 Jan., 20:26, GL <pfl...@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 (`).

______________________________________________
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.