prophet
|
There are two separate queries. You have to run them separately. Simply copy them then go to System Mgr then DE-A and past it in the window and execute or export. It will tell you if there are any duplicate part numbers in that file. If there are then you will need to use Maintain Database to fix it(aka delete one) select bkic_prod_code, count(*) from bkicmstr group by bkic_prod_code having count(*) > 1 Second query select mtic_prod_code, count(*) from mticmstr group by mtic_prod_code having count(*) > 1
|