Search found 1 match

by rooster25
Sat Mar 03, 2018 11:34 am
Forum: PATSTAT Product Line
Topic: Retrieving patents with inventors spread across multiple countries
Replies: 3
Views: 3900

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_...