[AccessD] Access to SQL

Hi all
 
I've moved Access XP FE to ADP FE and the tables to SQL 2000 BE. I now  find 
that Select DistinctRow thats in Access XP has no equivalent in SQL  2000. 
What is the equivalent syntax?
 
for example have the following sql string works in Access without a  problem. 
Load it into ADP ...and its a no no.
 
Any suggestions?
 
SELECT DISTINCTROW ApplicantPersonalDetails.*,  OrderDetails.CourseCounter, 
OrderDetails.OrderID, Orders.ClientID,  Orders.OrderDate, 
Orders.InvoiceRequired, ClientPurchaser.ClientCode,  ClientPurchaser.Purchasers, 
ClientPurchaser.FirstName, ClientPurchaser.LastName,  PostBasicCourseDetails.CourseID, 
PostBasicCourseDetails.Date,  PostBasicCourseDetails.Course, 
PostBasicCourseDetails.Level,  PostBasicCourseDetails.Location, PostBasicCourseDetails.Code,  
PostBasicCourseDetails.Length, PostBasicCourseDetails.Places,  
PostBasicCourseDetails.CourseLeader1, PostBasicCourseDetails.CourseLeader2,  
PostBasicCourseDetails.Cost, PostBasicCourseDetails.Selection

FROM          PostBasicCourseDetails INNER  JOIN
(((ClientPurchaser INNER  JOIN
Orders ON ClientPurchaser.ClientID = Orders.ClientID) INNER  JOIN
OrderDetails ON Orders.OrderID = OrderDetails.OrderID) INNER  JOIN
ApplicantPersonalDetails ON OrderDetails.OrderDetailID =  
ApplicantPersonalDetails.OrderDetailID) ON  
PostBasicCourseDetails.CourseCounter = OrderDetails.CourseCounter;
 
Regards
johnc