Sandbox — LSD is in active testing. All systems operational·payments are test-mode (no real charges).
Overview Use Cases News Docs Tool Store Support Community Get LSD
All docs
Docs/ API Reference/ Table/ join
Table· method

Table.join

joins to another table on a key column

Python
join(other: Table, on: str | list[str], how: str = "inner") -> Table

Returns Table — the joined Table

Parameters#

name type default description
other Table — the right-hand table to join against
on str | list[str] — key column(s) present in both tables
how str "inner" join type: "inner", "left", "right", or "outer"

Example#

Python
orders.join(customers, on="customer_id")

Keep every left row, filling unmatched right columns with nulls:

Python
orders.join(customers, on="customer_id", how="left")

Notes#

how accepts "inner" (default), "left", "right", and "outer". Join on multiple keys by passing a list to on. Every call returns a new Table.

See also#

API: group_by · select · with_column

Guides: Tables & data flow

By LSD Team · Last updated Jul 17, 2026 Ask on Discord View as Markdown