Svein Erling Tysvaer wrote:

> Hi Lester, long time, no conference!
>
> select TICKET_ID, TRANSACT_NO, count(*)
> from TRANSACTIONS
> group by 1, 2
> having count(*) > 1

Perfect - thanks SET

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php