ibis.expr.api.TableExpr.join

TableExpr.join(right, predicates=(), how='inner')

Perform a relational join between two tables. Does not resolve resulting table schema.

Parameters

• left (TableExpr) –

• right (TableExpr) –

• predicates (join expression(s)) –

• how (string, default 'inner') –

  • ‘inner’: inner join

  • ’left’: left join

  • ’outer’: full outer join

  • ’right’: right outer join

  • ’semi’ or ‘left_semi’: left semi join

  • ’anti’: anti join

Returns

joined – Note that the schema is not materialized yet

Return type

TableExpr