Short answer
HubSpot's KB: choose a primary data source, then add sources. Data join shows a graph of the join type. Use join keys to match left and right table columns, or the advanced join view from the Sources tab menu.
1. In HubSpot
The relevant screen in my demo portal.

2. Worth knowing
Datasets need Data Hub Enterprise.
3. Related
Datasets in workflows and reports.