>for example:
>
>I would like 1 current price per item per customer:
>
>These would be all the items a particular customer has bought in the past, with the current price of that item should he buy again in the future:
>
>CUSTCODE: ITEMNUMBER: PRICLIST: DESC: BASEPRICE BASEUNIT
>R02415 BE01060 C CLAMATO JUICE 8X1.98L 30.99 CASE
>R02415 BE01434 C WATER PERRIER 24X330ML 16.99 CASE
>R02415 BE05401 C APPLE JUICE 15.90 CASE
>
>However, I am getting multiple pricinf for the same item and customer:
>
>CUSTCODE: ITEMNUMBER: PRICLIST: DESC: BASEPRICE BASEUNIT
>R02415 BE01060 C CLAMATO JUICE 8X1.98L 28.75 CASE
>R02415 BE01060 C CLAMATO JUICE 8X1.98L 29.99 CASE
>R02415 BE01060 C CLAMATO JUICE 8X1.98L 30.99 CASE
>R02415 BE01434 C WATER PERRIER 24X330ML 16.59 CASE
>R02415 BE01434 C WATER PERRIER 24X330ML 16.95 CASE
>R02415 BE01434 C WATER PERRIER 24X330ML 16.99 CASE
>R02415 BE05401 C APPLE JUICE 13.29 CASE
>R02415 BE05401 C APPLE JUICE 15.90 CASE
Post the definition (table structure) of all tables involved in the query. You may also check recent example here
Message ID:
1473172
If it's not broken, fix it until it is.
My Blog