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

2009-04-26 Thread Wacek Kusnierczyk
Peter Dalgaard wrote: > 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

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

2009-04-26 Thread 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,

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

2009-04-26 Thread Gabor Grothendieck
1. ?merge 2. sqldf package whose home page is at: http://sqldf.googlecode.com On Sat, Apr 25, 2009 at 9:15 PM, 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

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

2009-04-26 Thread Nigel Birney
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. thanks a lot,