I have an ENUM List column with Type REF to another table. That table has the Key column, name column, and a price column.
How do I add the Price columns in the referenced table from the ENUM List?
Example:
Table Structure 1
| Key | | Name | | Price |
| abc | | 123 | | 50 |
| def | | 456 | | 25 |
Table Structure 2
| Key | | Enum list | | Total Price |
| ghi | | abc , def | | 75 |
My trouble is in adding the Total Price column in Table Structure 21 example
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |