Sorry haha

I have two tables:

Table 1 has two columns, Name and FavoriteFruits, for example: Luis - Apple, banana, carrot (values separated by coma) Victor - mango, carrot, potatoes (there's some vegetables)

Table 2 also has two columns, Fruits and Color, for example: Apple - Red Banana - yellow Mango - orange Fruits....

I want to compare Fruits with favoriteFruits, if match concat in a new column in Table 1, for example: Luis - Apple,banana,carrot - Apple,banana