Hi
Thanks Radu.
I can't use your sql because I need to run that query only for duplicate
records from that table. Probably I will create a procedure for that.

Paul


Hello,

AFAIR, IN queries are not well optimized.

Maybe something like this will help

select * from sys_products where
(select count(barcode) barcode from sys_barcode WHERE
sys_barcode.barcode=sys_products.barcode)>1