Google for sql join and see the examples in Example 4 on the sqldf home page: http://code.google.com/p/sqldf/#Example_4._Join
On Thu, Nov 19, 2009 at 2:30 PM, JoK LoQ <jok...@gmail.com> wrote: > > Hello, > > I would like some help with sqldf syntax. > > Suppose I have table 1 and table 2. > What do I have to do to generate a table with columns 2,5,6 from table 1 > (for example), and columns 3,4,5,9 from table 2, but only when values in > column 2 from table 1 are equal to values in column 5 from table 2. > > tnks > -- > View this message in context: > http://old.nabble.com/sqldf-tp26421449p26421449.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.