[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