FROM (SELECT DISTINCT targetname, targetstatecode, announceddate FROM mascore)a;
The mas distinct key count match the total count of the table so therefore the mascore table is clean.
==Name Based Matching companybase keys to mas keys==
==Creating Stage Flags Table==