buildJoinQuery: Build a JOIN SQL Query

In patelm9/pg13: pg13 Package

Description

A SQL query is built using the given arguments. Currently, only 1 whereIn and whereNot in parameters can be set.

Usage

buildJoinQuery(
  fields = "*",
  distinct = FALSE,
  schema,
  tableName,
  column,
  joinOnSchema,
  joinOnTableName,
  joinOnColumn,
  joinType = "LEFT",
  whereInField = NULL,
  whereInVector = NULL,
  whereNotInField = NULL,
  whereNotInVector = NULL,
  caseInsensitive = TRUE,
  n = NULL,
  n_type = c("limit", "random")
)

Value

SQL statement as a character string.

patelm9/pg13 documentation built on Dec. 26, 2021, 8:17 p.m.