Skip to Content
Aug 16, 2020 at 11:28 AM

Finding occurrence of a word in a database table using another Table

138 Views Last edit Aug 17, 2020 at 06:36 AM 2 rev

I want a open sql select query which can count the number of occurances of each word in the database table using another table

following is the scenario:

database Table1: t1


database table: t2


After query execution result should go in a internal table like shown

Internal table : Itab


Note : - The words column of T1 is of String format, so we cannot use it directly in where, order by, group by clause. It shows an error. So, Please provide a query keeping this in mind.


capture1.png (5.7 kB)
capture2.png (2.9 kB)
capture3.png (4.2 kB)