Is this the best way to select multiple columns from a table that has a distinct order ID field?
Thanks.
Swi
Code:
SELECT Master.[OrderID], Max(Master.[customer]) AS MaxOfcustomer, Max(Master.[quotedPrice]) AS MaxOfquotedPrice
FROM Master
GROUP BY Master.[OrderID];
Thanks.
Swi