Understanding the Dot Problem in SQLDF and How to Master sqldf's Syntax for Effective Data Manipulation.

Using SQL-like Queries with sqldf: Subsetting Data Frames in R