Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Incrementally load data from multiple tables in SQL Server to Azure SQL Database using PowerShell [!INCLUDE appliesto-adf-asa-md] In this tutorial, you create an Azure Data Factory with a pipeline ...

In this tutorial, you create an Azure data factory with a pipeline that loads delta data from multiple tables in on-premises SQL Server to an Azure SQL database.