R help - Nov 2009 - sqldf

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.

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