Hi I have two tables like below. Table 'a' can have multiple values in the field name while table 'b' can have only one value. Can I join these tables so that I get all the rows from table 'a' for which name exist in table b?
a
| Sr no | name |
| 1 | abc, def, ghi |
| 2 | jkl, mno |
| 3 | pqr |
| 4 | stu |
And another table like below
b
| id | name | | 11 | abc | | 12 | def | | 13 | ghi | | 14 | jkl | | 15 | mno | | 16 | pqr |
| |
| |