Search found 2 matches
- Tue Aug 30, 2016 1:12 pm
- Forum: PATSTAT Product Line
- Topic: How to retrieve applicant's address
- Replies: 5
- Views: 2977
How to retrieve applicant's address
Dear community, I'm working on a PATSTAT Online (Autumn 2015) patent query. My aim is to find the address of certain inventors who submitted an application in germany in a certain year. So I went with following query: SELECT DISTINCT TLS206_PERSON.SECTOR, TLS206_PERSON.HRM_L2, TLS206_PERSON.PERSON_A...
- Thu Aug 25, 2016 2:15 pm
- Forum: Patent Information Matters
- Topic: Help with SQL query - how to retrieve address
- Replies: 0
- Views: 2647
Help with SQL query - how to retrieve address
Dear community, I'm working on a PATSTAT Online (Autumn 2015) patent query. My aim is to find the address of certain inventors who submitted an application in germany in a certain year. So I went with following query: SELECT DISTINCT TLS206_PERSON.SECTOR, TLS206_PERSON.HRM_L2, TLS206_PERSON.PERSON_A...