thank you for this forum, and the possibily to get help.
using the patstat 2018b version, I want to find out about certain inventors from Germany who cite U.S. patents.
Is it sufficient to join the data using the tls211_pat_publn.pat_publn_id ?
My join would be:
So linking my German Inventors (GermanInventors) using the publn_id with cited_pat_publn_id and then using tls212_citation.pat_publn_id = tls211_pat_publn.pat_publn_id.
Code: Select all
INNER JOIN patstat2018b.dbo.tls212_citation ON PatAppl_GermanInventors.publn_id = tls212_citation.cited_pat_publn_id INNER JOIN patstat2018b.dbo.tls211_pat_publn ON tls212_citation.pat_publn_id = tls211_pat_publn.pat_publn_id
Or am I missing something?
Thank you very much.