Skip to content

Instantly share code, notes, and snippets.

@toyeiei
Created Feb 5, 2019
Embed
What would you like to do?
# join two tables and select all columns
sqldf("SELECT * FROM mtcars
JOIN customers
ON mtcars.ID = customers.ID;")
# join two tables and select some columns
sqldf("SELECT c.ID, m.models, m.mpg, c.year FROM mtcars m
JOIN customers c
ON c.ID = m.ID;")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment