0

I'm trying to do a simple left join using the sqldf (as I usually do):

tot3<-sqldf("select a.*, b.* 
from tot2 a 
left join lagd b on a.rowid = b.rowid+1")

but this time I received a message:

Error in result_create(conn@ptr, statement) : too many SQL variables

Does anybody know how can I overcome it?

Improve this question
4
  • 2
    What are the columns in the tot2 and lagd data frames? Can you include this information in your question? Commented Jun 21, 2018 at 1:22
  • 1
    Probable duplicate - stackoverflow.com/questions/41586868/… Commented Jun 21, 2018 at 2:16
  • Actually I think the problem is that there are several columns in each database (tot2 has 1010 and lagd 505). That is because I can't put all the columns here :( Commented Jun 21, 2018 at 2:55
  • Also, the column's name are not duplicate. Before the left join I changed the names of the lagd using "paste" function. I also check it again right now and everything's fine. Commented Jun 21, 2018 at 2:56
Related questions
2
SQLDF error - syntax error
1
sqldf select values from other table
4
SQLDF Left Join in R
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.