Search found 2 matches

by AthimetC
Wed Feb 17, 2021 7:58 am
Forum: PATSTAT Product Line
Topic: Duplicate Application ID
Replies: 2
Views: 591

Re: Duplicate Application ID

Dear Support Team

Thank you for your help. Using SELECT DISTINCT is really helpful and reduce a lot of data.

Best

Athimet
by AthimetC
Tue Feb 16, 2021 5:50 am
Forum: PATSTAT Product Line
Topic: Duplicate Application ID
Replies: 2
Views: 591

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...