Changes

FROM IPOClean AS A

JOIN MAClean AS B ON A.coname=B.coname AND A.statecode=B.statecode AND A.datefirstinv=B.datefirstinv;

I then pulled out the IPOs that were only IPOs and MAs that were only MAs.