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.