Try adding 'distinct' before the field you are selecting.
-Lisi
At 01:42 AM 6/8/02 +0100, Georgie Casey wrote:
Is there any SQL command that will return a list of *unique* entries from a
fied. ie only repeat one for duplicates
i have a database of products, each having a category, and
On Saturday 08 June 2002 08:42, Georgie Casey wrote:
Is there any SQL command that will return a list of *unique* entries from a
fied. ie only repeat one for duplicates
i have a database of products, each having a category, and obviously a lot
of products have the same category and I want to