[R] THE EQUIVALENT OF SQL INNER TABLE JOIN IN R

[Peter Dalgaard]

Nigel Birney wrote:
> Hello all,
> 
> Apologize for the newbie question. What's the easiest way to do a SQL inner
> table join in R? 
> 
> Say I have a table containing column names A, B, C and another which has
> columns named C, D, E. I would like to do an inner table join on C and
> produce a table A, B, C, D, E.

merge(), perhaps? Otherwise describe what an inner table join does.

	-pd

-- 
    O__  ---- Peter Dalgaard             Øster Farimagsgade 5, Entr.B
   c/ /'_ --- Dept. of Biostatistics     PO Box 2099, 1014 Cph. K
  (*) \(*) -- University of Copenhagen   Denmark      Ph:  (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)              FAX: (+45) 35327907