[R] sql query over local tables

Prof Brian Ripley ripley at stats.ox.ac.uk
Wed Aug 29 09:02:32 CEST 2007

On Tue, 28 Aug 2007, Jorge Cornejo Donoso wrote:

> Hi i have to table with IDs in each one.

And what is a 'table'?  If these are data frames, see ?merge.  If they are 
tables (which are arrays in R), then still use merge() if they can be 
converted to data frames.

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

No, they use the DBMS to do the hard work.

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

More information about the R-help mailing list