Dear Support Team

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

Best

Athimet

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