July 3rd, 2017, 01:48 AM
Join Date: Jul 2017
Time spent in forums: 43 m 17 sec
Reputation Power: 0
Need complex query help
I need help in setting up complex query.
I have a table "Event" which has event_id ,base_event_ids and name field
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.