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

Combining Row Names in Extensive Dataframes While Keeping Data Associated with Specific Rows Using ddply and summarise

Understanding SQL Joins in R with sqldf: A Practical Guide to Avoiding Duplicate Column Errors