It should work. We are only doing a distinct on the price. see below. Also this is a good example of running the same thing on a single table.

CREATE...

Not sure about the syntax but i would do something like this.

SELECT T1.A5CPGP AS [CUSTOMER PRICE GROUP],

T3.KIICID AS [ITEM KEY],

...