Page 1 of 1

Help with SQL query - how to retrieve address

Posted: Thu Aug 25, 2016 2:15 pm
by Hustenhaft
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.