[AccessD] Select question

thanks

----- Original Message ----- 
From: "Griffiths, Richard" <R.Griffiths at bury.gov.uk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, August 19, 2004 6:00 AM
Subject: RE: [AccessD] Select question


> Hi John
>
> I think the 'Select distinct' looks at the uniqueness of the columns
> returned in your query and select 'distinctrow' takes into account
> columns not returned by the query so
>
> Col1 Col2 Col3 (Col3 is not Returned but a row in the
> table)
> 1 A A C
> 2 A B C
> 3 A B D
>
> Select distinct would return rows 1 and 2
> Select distinctrow would return rows 1 and 2 and 3 (as it takes col3
> into account)
>
> Richard
>
>
>
> -----Original Message-----
> From: John Eget [mailto:joeget at vgernet.net]
> Sent: 19 August 2004 10:26
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Select question
>
> What is the difference between select distinct and select distinctrow.
> When would I use one instead of the other. I have looked and cannot find
> the answer
> Thanks
> John
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com