Peter,

Yes! Thank-you, Thank-you, Thank-you!

I can see now where I went wrong not joining the Order Details and grouping by productID.

Fortunately, this particular script doesn't suffer from the duplicates issue, although...

Peter,

Thank-you for your solution. I really thought you had it.

Unfortunately, it only works because in Northwind all the orderID's are in the same sequence as the orderdate. So,...

Thanks for your quick reply!

I'm trying to get the last order (max(orderdate) for each item. Ultimately, I'm building a separate association table between products and orders using only the latest order....