sqlOnClause: Compose an on clause for a table join

In schardtbc/DBIExt: Extentsion for DBI; new Generics

Description

'sqlOnClause()' generates a single SQL string that forms the on clause for joining two tables. The default methods are MariaDB, MySQL compliant. These methods are mostly useful for backend implementers.

Usage

sqlOnClause(con, x, y, by, ...)

Arguments

x, y	names of tbls to join. These will be quoted with dbQuoteIdentifier
by	a character vector of columns to join by. If 'NULL', the default, '*_join()' will do a natural join, using all variables with common names across the two tables. A message lists the variables so that you can check they're right (to suppress the message, simply explicitly list the variables that you want to join).

See Also

Other SQL generation: sqlAddIndex, sqlAlterTableWithPrimaryKey, sqlDeleteAllRecords, sqlReplaceInTable, sqlSetClause, sqlUpdateTable

schardtbc/DBIExt documentation built on June 7, 2019, 2:39 p.m.