Hi friends,
I have one table with cityid(int), cityname(string).
My table (City) will be like:
City_ID City_Name
1 Bengaluru
2 Hyderabad
3 Chennai
4 Goa
5 Kerala
In another table i have a field like city(values will be like '428,29,33')
I want to retrieve city names like ('bangalore,hyderabad,chennai').
My table (emp) like:
Emp_Name Emp_ID Emp_Location Emp_Desig
Peter 1 1,2,3 Developer
Sam 2 2,3,4 Hr
Prem 3 3,4,5 TechLead
Saketh 4 4,5,1 Designer
When want retrieve data from emp table I need data like
Emp_ID Emp_Location
1 Bengaluru, Hyderabad, Chennai
2 Hyderabad, Chennai, Goa
3 Chennai, Goa, Kerala
Can you please tell me how to do it?
Thanks in advance.