Create an SQL JOIN Expression

Source: R/sql_join.R

Create an SQL JOIN Expression

sqlJoinExpression(left, right, condition, type = "INNER")

Arguments

left

left part of JOIN (e.g. table name)
right

right part of JOIN (e.g. table name)
condition

condition
type

one of c("LEFT", "RIGHT", "INNER")