RE: OT DBMS select distinct

]] Sent: Thursday, May 24, 2001 11:21 PM To: CF-Talk Subject: RE: OT DBMS select distinct The key word distinct does not work that way. It will only allow duplicate record sets but does nothing for individual fields unless it is a one field query. A work around is as follows but depending

RE: OT DBMS select distinct

The key word distinct does not work that way. It will only allow duplicate record sets but does nothing for individual fields unless it is a one field query. A work around is as follows but depending on the data set . Hope this helps. John select r.ResourceID, r.Name, r.Description,

Re: OT DBMS select distinct

up. Bryan - Original Message - From: John [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 24, 2001 10:20 PM Subject: RE: OT DBMS select distinct The key word distinct does not work that way. It will only allow duplicate record sets but does nothing for individual