I have two sets of data. This would be

Data set 1
Application number Type of application
12356 easy
25689 Hard
23656 easy
23548 easy
89541 Hard
32556 easy
etc

Data set 2 is my master data which has the application numbers and 15 other columns of data but this data does not have Type of application. The number of lines of data amounts to 6000. How can i add the type of application from dataset 1 to dataset 2 by linking to the application number?

Thanks for your help. Bottle of virtual wine available...lol