> ## 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.

# join_to_view

> Specifies the view to join to the source view.

This parameter works in conjunction with [`join_from_view`](/modeling/relationships/parameters/join-from-view) to establish the relationship between two views in your data model.

## Limitations

Views representing a [data input table (CSV/XLSX upload)](/analyze-explore/data-input-csvs) can't be used in a join unless the table has been uploaded to a database. This requires defining an **Upload schema** for the underlying database connection.

## Syntax

```yaml theme={null}
join_to_view: <target_view>
```

## Properties

<ParamField path="join_to_view" type="string" required>
  The name of the view to join into the source view. This view must exist in your data model.
</ParamField>

## Examples

```yaml title="Join buyers to user_facts" highlight={2} theme={null}
- join_from_view: buyers
  join_to_view: user_facts
  join_to_view_as: buyer_facts
  join_type: always_left
  on_sql: ${buyers.id} = ${buyer_facts.id}
  relationship_type: one_to_one
```
