Hi, I have 2 tables... in one, I have a filed that is a text type and I store a list of indexes from the other table (one per line).
TABLE A (fields: ..........., SECTORES,........)
TABLE B (fields: id_sector, name)
So when a make a query to, the field SECTORES has
But I want it to show the name that corresponds to that index. I can't doit via a join o WHERE because SECTORES its not a field with 1 value but a list of values...
I was trying to do it with REPLACE and SUBSTRING_INDEX..... but I can't figure it out ......
I was thinking on doind that.... but the problem is how do I represent the list? I can't add a field per each one because it's not a fixed number... maybe with only 1 field pointing to a table that represents the list?