No only duplicates, some tables have orphan records
Anyways.......
SELECT BKIC_PROD_CODE, COUNT(*) TotalCount
FROM BKICMSTR
GROUP BY BKIC_PROD_CODE
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
Go to System Mgr
Open DE-A
Paste the query, and click on "Execute"
if you don't have that menu go to
System Mrg
Open UT-A
and enter: SQLEXPORT.RWN
You got Duplicates!!!!
http://www.istechforum.com/YaBB.pl?num=1281714671 Orphan Records
Kelloggs