MOST COMPLICATED query ever

[dastr]

Hi all,
I have the following two tables (you may also refer to attachment)
Table A
Person Index Symbol
Inna - T1 - alpha
Inna - T4 - beta, theta, delta
Maria - T1 - delta, theta
Maria - T4 - alpha, gamma

And

Table Conversion
Symbol Index Combination Symbol value
Alpha - alphaT1 - 10


Beta - betaT1 - 18
Gamma - gammaT1 - 14
Delta - deltaT1 - 100
Theta - thetaT1 - 1
Alpha - alphaT4 - 10
Beta - betaT4 - 18
Gamma - gammaT4 - 14
Delta - deltaT4 - 100
Theta - thetaT4 - 1

And the idea is to get:

Table Outcome
Person SymbolValues Lowest Value
Inna - 10- 10
Inna - 18,100,1 - 1
Maria - 100,1 - 1
Maria - 10,14 - 10

Logic: in table Conversion we look for the symbol value on basis of Index and Symbol from Table A; these values get populated in Symbol value in table Outcome and then we need the Lowest Value of the latter in column Lowest Value Table Outcome.

Does anyone know how this could be done?
Thank you VERY VERY much!

[recyan]

The first thing that comes to mind,
Why is symbol stored in Table A, the way it is stored ?

Table A
Person Index Symbol
Inna - T1 - alpha
Inna - T4 - beta, theta, delta
Maria - T1 - delta, theta
Maria - T4 - alpha, gamma

Why Not

Table A
Person Index Symbol
Inna - T1 - alpha
Inna - T4 - beta
Inna - T4 - theta
Inna - T4 - delta
Maria - T1 - delta
Maria - T1 - theta
Maria - T4 - alpha
Maria - T4 - gamma


And

Is there any particular reason for "Combination Symbol" field ?

Table Conversion
Symbol Index Combination Symbol value
Alpha - alphaT1 - 10
Beta - betaT1 - 18
Gamma - gammaT1 - 14
Delta - deltaT1 - 100
.....

Thanks