Skip to content

Instantly share code, notes, and snippets.

@toyeiei

toyeiei/sqldf4.r

Created February 5, 2019 07:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save toyeiei/963cd0cf792d67c41bf4b7f36bb438f3 to your computer and use it in GitHub Desktop.
Save toyeiei/963cd0cf792d67c41bf4b7f36bb438f3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqldf4.r
# 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