Enum list Lookup

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

0 1 295
1 REPLY 1

Steve
Platinum 4
Platinum 4
Top Labels in this Space