[R] sql query over local tables

[Gabor Grothendieck]

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:

http://sqldf.googlecode.com


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