string - SELECT statement from two dataframes using RMySQL -

consider 2 data frames, dataframe1 , dataframe2:

• dataframe1 has n columns (colmn1, ..., colmnn)
• dataframe2 has 3 columns (col1, col2, col3)

can write statement like:

select colmn1, colmn2, ..., colmnn, col1, col2 dataframe1, dataframe2 

using rmysql?

maybe want package sqldf instead.

try this:

library("sqldf") sqldf("select colmn1, colmn2, ..., colmnn, col1, col2 dataframe1, dataframe2") 

of course must replace ... actual column names.