[R] sql query over local tables

Gabor Grothendieck ggrothendieck at gmail.com
Wed Aug 29 12:28:56 CEST 2007

I assume that by "local tables" you mean data frames in R.

You can use the merge function in the base of R, as others have already
mentioned, or if you want to use SQL syntax you can use the sqldf
package.  See example 4 on the sqldf home page:


On 8/28/07, Jorge Cornejo Donoso <jorgecornejo at uach.cl> wrote:
> Hi i have to table with IDs in each one.
> I want to make a join (as in sql) by the ID. Is any way to use the RODBC
> package (or other) in local tables (not a access, mysql, sql, etc. )  and
> made the join?
> Thanks in advance
> ______________________________________________
> R-help at stat.math.ethz.ch 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.

More information about the R-help mailing list