Search found 1 match

by rfuchs
Wed Jul 20, 2016 6:10 pm
Forum: PATSTAT Product Line
Topic: Help with SQL query - how to retrieve year & company
Replies: 1
Views: 2200

Help with SQL query - how to retrieve year & company

Dear community, I'm working on a PATSTAT Online (Spring 2016) patent query. My aim is to find all the entries that include the applications made by a certain company, in a certain year (filing date). The only table where I could find entries related to the companies is the tls206_person > psn_name. ...