I have above tables as input tables.
from table 1 when subclass=100, I want to take number column and from table 2 when filter=40 I will have comma separated ID's which will be fed to the table 3. from table 3 I want the concatenated values from the column value as shown in expected output.
The expected output is as shown in table
table2.id=table1.id for getting number and table1.number and table2.text
I need a sql query to get the expected output