Skip to contents

Generate SQL for LEFT JOIN

Usage

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