Search found 1 match
- Sat Mar 03, 2018 11:34 am
- Forum: PATSTAT Product Line
- Topic: Retrieving patents with inventors spread across multiple countries
- Replies: 3
- Views: 3974
Retrieving patents with inventors spread across multiple countries
I am trying to retrieve patents that have more than one inventor and the inventors are situated in different countries. I have written this: CREATE VIEW nt AS [SELECT tls201_appln.appln_id, tls201_appln.appln_filing_year, tls206_person.psn_id, tls206_person.person_ctry_code FROM tls201_appln,tls206_...