Dear Geert Boedt,

Thank you so much for you help and you really solved my problems.
Best wishes,
aleric

Hello PATSTAT community, I am currently working for my PhD thesis and collecting all the Japan smart grid technologies. But I am currently stuck with the query. I am using the CPC classification +keywords to collect the patent data. The detailed query is SELECT distinct(a.appln_id) FROM tls201_appln...