>Hello Naomi,
>
>As with Borislav's SQL statement as well, :
>
>I ran the SQL statement and it gives me many BASEPRICE per CUSTCODE AND ITEMNUMBER.
>
>I don't know why it is returning multiple records for the same custcode and itemnumber.
>
>I want 1 record with the current base price only.
>
>If there something I am missing?
>
>John
Use the query I posted. You need to join with the result of the GROUP BY.
If it's not broken, fix it until it is.
My Blog