Help with SQL query - how to retrieve address

Here you can find announcements regarding the EPO's patent information products and services, events and activities.

Please also feel free to ask questions and share information on general patent information matters.
Post Reply

Hustenhaft
Posts: 2
Joined: Thu Aug 25, 2016 1:19 pm

Help with SQL query - how to retrieve address

Post by Hustenhaft » Thu Aug 25, 2016 2:15 pm

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_ADDRESS
FROM TLS201_APPLN
LEFT JOIN TLS207_PERS_APPLN ON TLS201_APPLN.APPLN_ID = TLS207_PERS_APPLN.APPLN_ID
LEFT JOIN TLS206_PERSON ON TLS207_PERS_APPLN.PERSON_ID = TLS206_PERSON.PERSON_ID
WHERE
UPPER (TLS201_APPLN.APPLN_AUTH) = 'DE'
AND TLS201_APPLN.EARLIEST_FILING_YEAR = 2000
AND TLS206_PERSON.SECTOR NOT LIKE 'INDIVIDUAL'
AND TLS206_PERSON.PERSON_CTRY_CODE = 'DE'
AND TLS207_PERS_APPLN.INVT_SEQ_NR > 0;

It seems to work as intended. But following problem has occurred: The attribute address (TLS206_PERSON.PERSON_ADDRESS) stays empty, even though the attribute in the table TLS206_PERSON is not. I tried different approaches, but i can not seem to solve this problem. If try to look up the address of a match found afterwards, it clearly is not empty too.

Thanks in advance.


Post Reply