[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