You'll need to join your two tables, to do this bring both tables into the data source window:
Create an inner join based on the department ID as the key.
Then create a view like below:
Please see the attached workbook, thanks.
Department Join.twbx 23.3 KB
The output must be as below department name must NOT be in another column
Date of Joining
Merchandise 0102 James 10.02.2018 0305 Laura 06.06.2000 Information Technology 0203 Steve 12.24.1991 Administration 0215 Mark 04.03.2002