Generate (Base Part of) SQL for LEFT JOIN

Source: R/sql_join.R

Generate (Base Part of) SQL for LEFT JOIN

sqlLeftJoinBody(
  leftSql,
  rightTable,
  id,
  idLeft = id,
  useAlias = (id != idLeft),
  aliasName = "tbase"
)

Arguments

leftSql

SQL of subquery that provides the "base" table on the left
rightTable

name of "right" table
id

name of ID field of "right" table (must correspond to a field returned by leftSql)
idLeft

name of ID field of "left" table
useAlias

if TRUE, the alias given in aliasName is given to the subquery leftSql. Default: FALSE
aliasName

alias name to be used if useAlias is TRUE. Default: "tbase"