Relational DB in R-environment

[Mariano Tomatis]

Hi,
is it possible to "link" with an INNER JOIN two dataframes in R-
environment, as in any relational DB?
Many statistical environments enable the user to do it (i.e. SAS).

Having table A and table B linked with a key ID, I tried to do it by
adding new columns to table B with the same name as in A and using a
function like:

B$NAME <- ""
for(i in A$ID) B$NAME[B$ID==i] <- A$NAME[A$ID==i]

but it is soooooo slooooooow....

Thank you for any help.

Mariano Tomatis

[Mariano Tomatis]

Sorry, I probably solved the problem with this:
http://stat.ethz.ch/R-manual/R-patched/library/base/html/merge.html

:-)
Mariano