Here is a problem I am trying to solve:

I have a set of data, and I am trying to grab the data with the most recent changes made to it using a date reference. My problem is that the distinct will only let me get one field, which is not my unique ID field. I need to be able to get all of the data for each row but only get the unique rows.

Code:
SELECT DISTINCT dbtNAME FROM myTAble
This code gets the two records but only retrieves the field named dbtNAME and I need all of the columns.



Code:
SELECT DISTINCT dbtName,* FROM myTable
This code grabs all records from myTable


I am using SQL 7.0, VB 5.0, and ADO 2.1

Thanks in advnace