# Join dataset with YouPrep™

{% hint style="warning" %}
This page is deprecated thanks to the introduction of Hybrid pipelines, JOIN step (and APPEND step can be applied in all contexts. For more information about the execution of the JOIN step in an hybrid pipeline context see [here](/data-management-in-datahub/datasets-in-toucan/preparing-data/hybrid-pipeline.md).
{% endhint %}

You will find below, the possibilities to join datasets depending on the source of the dataset, the type of the joined dataset and the storage type defined for the actual dataset.

Here are some additional informations about wording used in the table:

* Live dataset from stored: a dataset created directly or indirectly from a stored dataset
* Live dataset from full live: a live dataset created indirectly from a connector with only live datasets between the connector and the dataset

<table><thead><tr><th width="239">Source of the dataset</th><th width="224">Type of dataset joined</th><th width="147">Saving storage</th><th>Managed</th></tr></thead><tbody><tr><td>Connector</td><td>Stored dataset</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Connector</td><td>Stored dataset</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Connector</td><td>Live dataset from stored</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Connector</td><td>Live dataset from stored</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Connector</td><td>Live dataset from full live</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="274c">❌</span></td></tr><tr><td>Connector</td><td>Live dataset from live</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="274c">❌</span></td></tr><tr><td>Stored dataset</td><td>Stored dataset</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> (except when using geographical steps)</td></tr><tr><td>Stored dataset</td><td>Stored dataset</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Stored dataset</td><td>Live dataset from stored</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> (except when including variables)</td></tr><tr><td>Stored dataset</td><td>Live dataset from stored</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Stored dataset</td><td>Live dataset from full live</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="274c">❌</span></td></tr><tr><td>Stored dataset</td><td>Live dataset from full live</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="274c">❌</span></td></tr><tr><td>Live from stored</td><td>Stored dataset</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Live from stored</td><td>Stored dataset</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Live from stored</td><td>Live dataset from stored</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> (except when including variables)</td></tr><tr><td>Live from stored</td><td>Live dataset from stored</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Live from stored</td><td>Live dataset from full live</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="274c">❌</span></td></tr><tr><td>Live from stored</td><td>Live dataset from full live</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="274c">❌</span></td></tr><tr><td>Live dataset from full live</td><td>Stored dataset</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Live dataset from full live</td><td>Stored dataset</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Live dataset from full live</td><td>Live dataset from stored</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Live dataset from full live</td><td>Live dataset from stored</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Live dataset from full live</td><td>Live dataset from full live</td><td>Live</td><td><span data-gb-custom-inline data-tag="emoji" data-code="274c">❌</span></td></tr><tr><td>Live dataset from full live</td><td>Live dataset from full live</td><td>Stored</td><td><span data-gb-custom-inline data-tag="emoji" data-code="274c">❌</span></td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs-v3.toucantoco.com/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/combine/join-dataset-with-youprep-tm.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.