View source: R/code_sql_join.R
code_sql_join | R Documentation |
SQL code to join table
code_sql_join(sql, table_to_join, by, sel.cols = "*", join_type = "inner")
sql |
an object of type code_sql_sample, character in SQL format that has SQL which selects records |
table_to_join |
the table that you want to join to |
by |
the SQL string criteria that joins the records (ie: X.a = Y.a) |
sel.cols |
the columns from the supplied sql that you would like to select |
join_type |
the type of join (ie: inner, left, right) |
Joins table to sql query
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.