KR or WO as countries publication
Posted: Thu May 19, 2022 2:27 pm
I'm trying to extract the patents that have Artificial intelligence in the title or abs filed in Korea or WO, besides that use distintct, so i dont double the inventions, but i dont know how to include WO and where put distinct. Can you guys help me?
Code: Select all
SELECT *
FROM TLS201_APPLN AS APP
INNER JOIN TLS202_APPLN_TITLE AS TIT
ON (APP.APPLN_ID = TIT.APPLN_ID)
INNER JOIN TLS203_APPLN_ABSTR ABS
ON (APP.APPLN_ID = ABS.APPLN_ID)
WHERE ( TIT.APPLN_TITLE LIKE '%인공 지능%' OR TIT.APPLN_TITLE LIKE '%Artificial intelligence%' OR ABS.APPLN_ABSTRACT LIKE '%인공 지능' OR ABS.APPLN_ABSTRACT LIKE '%Artificial intelligence%')
AND APP.GRANTED = 'Y'
AND APP.APPLN_FILING_YEAR BETWEEN '2003' AND '2017'
AND APP.APPLN_AUTH = 'KR'