Subject RE: [firebird-support] Re: Verry slow querry on FB 2 (getting OT)
Author Paul Mercea
Thanks SET

select * from sys_products sp
where not exists(select * from sys_barcode sb1
join sys_barcode sb2 on sb1.barcode = sb2.barcode
and sb1.pk < sb2.pk
where sb1.barcode = sp.barcode)

This works fast enough...i will se if data are ok to.

Paul