> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

# where_sql

> Adds a WHERE clause to the generated SQL when a join is established.

This parameter applies a filter condition to all rows in the query after the join has been performed. The clause does **not** pre-filter then join; it joins first and then uses the `WHERE` statement to filter the results.

## Syntax

```yaml theme={null}
where_sql: <sql_filter_condition>
```

## Properties

<ParamField path="where_sql" type="string">
  A SQL condition that filters rows after the join is performed. Use `${view_name.field_name}` syntax to reference fields.
</ParamField>

## Examples

```yaml title="Only include rows with order counts greater than 20" highlight={6} theme={null}
- join_from_view: users
  join_to_view: orders
  join_type: always_left
  on_sql: ${users.id} = ${orders.id}
  relationship_type: many_to_one
  where_sql: ${orders.count} < 20
```