Text files are in:<code>E:\McNair\Projects\Venture One Data\</code>#<code>summarytablefinal</code>: summary on number of patents and grant year for all companies#<code>ullyjoinedtable</code>: all patent and assignee information for entities that have patents (combining 3 and 4)#<code>fullyjoinednow</code>: patent information under current name of the company#fullyjoinedprec<code>fullyjoinedprev</code>: patent information under previous name of the company A new version of sql script can be cound at :<code>E:\McNair\Projects\Venture One Data\sql script.txt</code>