[AccessD] Select question

Exactly.

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Griffiths,
> Richard
> Sent:	Thursday, August 19, 2004 6:00 AM
> To:	Access Developers discussion and problem solving
> 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