Home > Workload Solutions > SQL Server > Guides > Dell ObjectScale and Integrated Systems for Data Analytics using Microsoft Azure HCI and SQL 2022 > Use case 3: Combining local and external tables
In this use case, we will join local table (weatherDescriptionPrecipitationPrabability) with external table (dt_ weather_description) for data analysis.
The following example is data of local weatherDescriptionPrecipitationPrabability table.
select * from [weatherDescriptionPrecipitationProbability]
This result contains a mapping of weather description and probability of precipitation.
Example data of external dt_weather_description table.
select distinct dwd.Vancouver from dt_weather_description dwd where Vancouver in ('broken clouds','scattered clouds','sky is clear')
This result shows distinct weather descriptions of Vancouver city.
The following example shows how to join these two tables to analyze precipitation of a given city based on weather conditions.
select wdpp.precipitation,dwd.Vancouver from dt_weather_description dwd left join weatherDescriptionPrecipitationPrabability wdpp
on dwd.Vancouver =wdpp.weatherDescription