Need complex query help

Hi Guys,

I need help in setting up complex query.

I have a table "Event" which has event_id ,base_event_ids and name field

eg

10 | 1,2,3 | Apple

where 10 is event_id
1,2,3 are base_event_ids
Apple is Name


I need result like below:

10 | Apple
10 | Mango
10 | Banana
10 | Pear

Mango is ( select Name from Event where event_id=1)
Banana is ( select Name from Event where event_id=2)
Pear is ( select Name from Event where event_id=3)

So basically i need a common event_id with its base event ids' and their names.


Is that possible , please suggest.

Thanks,
Sameer