Generate SQL for LEFT JOIN

Source: R/sql_join.R

Generate SQL for LEFT JOIN

sqlLeftJoin(sqlSource, tablesAndIDs, fields = "*")

Arguments

sqlSource

SQL of subquery that provides the "base" table on the left
tablesAndIDs

named character vector with the names representing the names of the tables to be joined and the values representing the ID fields of these tables
fields

fields to be selected