To connect the tables on the canvas, you can select a Join from the Palette, select a table, and drag the cursor from one table to another table. The New Join wizard is opened so you can define the parameters for a new join. This process is repeated until all tables on the canvas are joined.
The joined tables represent one logical input table. This logical input table contains all columns of the joined tables.
You can view the properties of each table join in the Join properties view. You can open the Join properties view by double-clicking a join on the canvas in the Design Studio.