sqlForInsertFromSelect: SQL for INSERT FROM SELECT

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

SQL for INSERT FROM SELECT

Description

Generate SQL INSERT statement of the form INSERT INTO target.table (fields) SELECT fields FROM source.table

Usage

sqlForInsertFromSelect(target.table, source.table, fields)

Arguments

target.table	name of target table
source.table	name of source table or SQL providing source data
fields	vector of character with field names

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