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 <[EMAIL PROTECTED]> 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@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. > ______________________________________________ R-help@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.
