[R] sqldf

Gabor Grothendieck ggrothendieck at gmail.com
Fri Nov 20 00:25:33 CET 2009


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 <jokloq at 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 at 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.
>




More information about the R-help mailing list