FROM ptoproperty_cleaned M1, ptoassignmentnd M2
WHERE (M1.reelno = M2.reelno) AND (M1.frameno = M2.frameno);
--8699074
Ptotracking2 adds the assignee to the transaction, allowing the user to track ownership of the entity and of the patent.
FROM ptotracking M1, ptoassigneend M2
WHERE (M1.reelno = M2.reelno) AND (M1.frameno = M2.frameno);
--9613927
===US ONLY Patent Assignee Table===