Subject | RE: [firebird-support] Re: Verry slow querry on FB 2 (getting OT) |
---|---|
Author | Paul Mercea |
Post date | 2006-02-20T13:32:16Z |
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
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