---
title: "Merge Tables and Create Virtual Joins Across Databases | DreamFactory"
description: "DreamFactory inspects the schema of every database it connects to, which makes it possible to join data that lives in separate systems through a single API…"
url: "https://www.dreamfactory.com/videos/virtual-joins-across-databases"
---

[Home](https://www.dreamfactory.com/) › [Videos](https://www.dreamfactory.com/videos) › Merge Tables and Create Virtual Joins Across Databases

# Merge Tables and Create Virtual Joins Across Databases

Tutorial·20 August 2025·7 min 57 sec

DreamFactory inspects the schema of every database it connects to, which makes it possible to join data that lives in separate systems through a single API call. This tutorial merges tables and builds virtual joins across disparate databases — the practical core of a data mesh approach.

## What you’ll learn

* How automatic schema inspection enables cross-database joins
* Merging tables that live in different database engines
* Returning joined data from a single API call

[Book a Demo](https://www.dreamfactory.com/demo)[More on our YouTube channel](https://www.youtube.com/@DreamfactoryAPI)

## More videos

* [Instantly Generate a REST API for Snowflake](https://www.dreamfactory.com/videos/snowflake-rest-api)
* [Read and Write Iceberg Tables in Snowflake via REST](https://www.dreamfactory.com/videos/snowflake-iceberg-tables-api)
* [Creating a SQL Server API in Minutes](https://www.dreamfactory.com/videos/sql-server-api-walkthrough)
* [Instantly Generate a Secure SQL Server REST API](https://www.dreamfactory.com/videos/sql-server-rest-api)

[Browse all videos ›](https://www.dreamfactory.com/videos)

Video: https://www.youtube.com/watch?v=CUf9Qek7HKE