As I remember, NULLs may be causing a problem here.
Alan
-----Original Message-----
From: Arno Brinkman [mailto:firebird@...]
Sent: Tuesday, 12 November 2002 22:13
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Problem creating UNIQUE index..


Hi,

> select BARCODE,NR_ORDINE,COUNT(*) from BARCODE
> GROUP BY BARCODE,NR_ORDINE
>
> the index is : BARCODE,NR_ORDINE
>
> Can someone help me?

The result of :

SELECT
BARCODE,
NR_ORDINE,
COUNT(*)
FROM
BARCODE
GROUP BY
BARCODE,
NR_ORDINE
HAVING
COUNT(*) > 1

is empty ?

Regards,
Arno



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]