Skip to contents

Generate (Base Part of) SQL for LEFT JOIN

Source: R/sql_join.R
sqlLeftJoinBody.Rd

Generate (Base Part of) SQL for LEFT JOIN

Usage

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"