R sqldf: Error table already in test

Question

I tested the code before and it didn't give me any errors. Now there is an error "sqldf: table T1 already in test". How can I fix it?

ret <- sqldf("SELECT T1.*, T2.score FROM T1 JOIN T2 USING(date)")

Answer 1

You just need to execute:

sqldf("drop table test.T1")

Answer 2

You may have a dataframe with the same name as your database table. Clear your environment and try again.