[R-sig-Geo] R equivalent of join between two data frames

[Ralf Schäfer]

Hi Erin,

as pointed out you can query a left inner join with all.x=T and a right inner join with all.y=T, incomparable is probaly to distinguish an inner and outer join, though I have not found the specifications in the merge functions.

Apart from that you can use SQL statements in R directly - here is a nice example:
http://gettinggeneticsdone.blogspot.com/2010/05/use-sql-queries-to-manipulate-data.html

Best regards
Ralf

------------------------------------------------------------

Prof. Dr. rer. nat. Ralf Bernhard Schäfer
Juniorprofessor for Quantitative Landscape Ecology
Environmental Scientist (M.Sc.)
Institute for Environmental Sciences
University Koblenz-Landau
Fortstrasse 7
76829 Landau
Germany
Mail: schaefer-ralf at uni-landau.de
Phone: ++49 (0) 6341 280-31536
Web: http://tinyurl.com/6dnpxna