Dear Support Team
Thank you for your help. Using SELECT DISTINCT is really helpful and reduce a lot of data.
Best
Athimet
Search found 2 matches
- Wed Feb 17, 2021 7:58 am
- Forum: PATSTAT Product Line
- Topic: Duplicate Application ID
- Replies: 2
- Views: 1651
- Tue Feb 16, 2021 5:50 am
- Forum: PATSTAT Product Line
- Topic: Duplicate Application ID
- Replies: 2
- Views: 1651
Duplicate Application ID
Hi there, I have a question about the SQL code below: 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...