Skip to contents

SQL for INSERT FROM SELECT

Source: R/sql_top_level.R
sqlForInsertFromSelect.Rd

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