ibis.expr.api.TableExpr.inner_join

TableExpr.inner_join(self, other, predicates=())

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

Parameters
leftTableExpr
rightTableExpr
predicatesjoin expression(s)
howstring, 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
joinedTableExpr

Note that the schema is not materialized yet