left_join
Performs a left join between two tables.
Syntax
left_join(<leftTable>, <rightTable>, <leftColumn>, <rightColumn>)
| Parameter | Type | Description |
|---|---|---|
| leftTable | Table | The Lefttable table. |
| rightTable | Table | The Righttable table. |
| leftColumn | any | The Leftcolumn value. |
| rightColumn | any | The Rightcolumn value. |
Return values
Table
Usage
Joins orders with customers table, keeping all orders even if customer data is missing.
left_join(orders, customers, orders.customer_id = customers.id)