Duplicate Application ID
Posted: Tue Feb 16, 2021 5:50 am
Hi there,
I have a question about the SQL code below:
I found that there are many application ID numbers which are duplicate, is it correct?
Please help,
Best
Athimet
I have a question about the SQL code below:
Code: Select all
SELECT a.appln_id, a.appln_kind, a.ipr_type, a.granted, a.appln_filing_date, a.nb_citing_docdb_fam,
t.appln_title,
ab.appln_abstract,
c.ipc_class_symbol,
ap.psn_name, ap.psn_id, ap.person_ctry_code, ap.psn_sector,
pub.publn_date
FROM tls201_appln a
JOIN tls203_appln_abstr ab ON a.appln_id = ab.appln_id
JOIN tls202_appln_title t ON a.appln_id = t.appln_id
JOIN tls209_appln_ipc c ON a.appln_id = c.appln_id
JOIN tls211_pat_publn pub ON a.appln_id = pub.appln_id
JOIN tls212_citation ci ON pub.pat_publn_id = ci.pat_publn_id
JOIN tls207_pers_appln ON a.appln_id = tls207_pers_appln.appln_id
JOIN tls206_person ap ON tls207_pers_appln.person_id = ap.person_id
WHERE c.ipc_class_symbol LIKE 'A01G%' -- Change IPC symbol here
-- AND a.appln_filing_date BETWEEN '1980-01-01' AND '2020-12-31'
-- AND a.appln_filing_date BETWEEN '1980-01-01' AND '2012-12-31'
AND a.appln_filing_date BETWEEN '2013-01-01' AND '2020-12-31'
AND tls207_pers_appln.applt_seq_nr > 0 -- i.e. applicants only
AND ap.psn_sector LIKE 'COMPANY'
ORDER BY a.appln_filing_year, a.appln_id
Please help,
Best
Athimet