[AccessD] Access to SQL

Can't quite remember off hand but I think if you change DISTINCTROW to just
DISTINCT that may work 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Johncliviger at aol.com
Sent: 18 August 2005 12:40
To: accessD at databaseadvisors.com
Subject: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com