Hi, i have two data sets that needs to be comapred and extract the caterogies from Data set x that doesn't match with Data set Y Dataset x Grade Subject Categories 6 PE Independent Work 6 PE Formative 6 PE Summative 7 PE Independent Work 7 PE Weekly Assessment 7 PE Monthly Assessment DataSet Y Grade Subject Categories 6 PE Independent Work 6 PE Testing 6 PE Summative 7 PE Assignment 7 PE Weekly Assessment 7 PE Monthly Assessment Output should be: Grade Subject Categories Correct Category 6 PE Summative Testing 7 PE Independent work Assignment1 Thanks,

Select x.grade,x.subject,x.categories from x left join y on x.grade = y.grade and x.subject=y.subject where x.categories<>y.categories