sqlLeftJoinBody: Generate (Base Part of) SQL for LEFT JOIN

In KWB-R/kwb.db: Functions supporting data base access

Generate (Base Part of) SQL for LEFT JOIN

Description

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"

KWB-R/kwb.db documentation built on Oct. 1, 2023, 4:10 a.m.