>>>>> On Tue, 18 Jun 2002 16:38:02 +0300, Andrew Guts <andr@...> said:

AG> Sure, but x.id is a primary key. And 'max(cx.id)' as an
AG> aggregate function should return only one value or NULL.

Uhm, what does return the following query?

SELECT id, count(*)
FROM transfers
GROUP BY id
HAVING count(*)>1

ciao, lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.