SQL for INSERT FROM SELECT

Source: R/sql_top_level.R

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

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