Is the table ActionRating in your latest query the same as the table ActionRatingDuns in your earlier table?

Actually, how about posting the DDL for the table(s) involved in your latest query, sample data for the table(s), and expected results. Also, how does this all relate to the original question you asked?