The return I want is by the Account Name, and the Product Names of the Core range that is missing.

Account Table

Account Name

AAA

BBB

Product Table

Product Name, Range

ProdAA, Core

ProdBB, 2nd

ProdCC, COre

AccountProduct Table

Account, Product

AAA,...