[R] sql query over local tables

[ONKELINX, Thierry]

Jorge,

I'm assuming that you mean dataframes of matrices. Then you could use
merge to join both dataframes into a new one. See ?merge for more
detail.

HTH,

Thierry

------------------------------------------------------------------------
----
ir. Thierry Onkelinx
Instituut voor natuur- en bosonderzoek / Research Institute for Nature
and Forest
Cel biometrie, methodologie en kwaliteitszorg / Section biometrics,
methodology and quality assurance
Gaverstraat 4
9500 Geraardsbergen
Belgium
tel. + 32 54/436 185
Thierry.Onkelinx op inbo.be
www.inbo.be 

Do not put your faith in what statistics say until you have carefully
considered what they do not say.  ~William W. Watt
A statistical analysis, properly conducted, is a delicate dissection of
uncertainties, a surgery of suppositions. ~M.J.Moroney

 

> -----Oorspronkelijk bericht-----
> Van: r-help-bounces op stat.math.ethz.ch 
> [mailto:r-help-bounces op stat.math.ethz.ch] Namens Jorge Cornejo Donoso
> Verzonden: dinsdag 28 augustus 2007 22:05
> Aan: r-help op stat.math.ethz.ch
> Onderwerp: [R] sql query over local tables
> 
> 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 op 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.
>