Your code should have in operator in subqueries
Select ServiceId, ClassId from ServiceMaster, ClassMaster
Where Not Exists(Select ServiceId, ClassId from ServiceRateMaster where ServiceId In(Select ServiceId from ServiceMaster) and ClassId in (Select ClassId from ClassMaster))
Order By ServiceId ,ClassId