simple database problem
simple database problem
Out of context: Reply #1
- Started
- Last post
- 4 Responses
- AlphaDK0
The cleanest way to do this would be to follow the last example that you have listed.
I would suggest using three tables and simply joining them together and grouping by your desired output column.
You could use REGEXP and SUBSTR and build a big nasty query based on a character delaminated string held in a single table column, but again, that would be nasty.