Re: Sub-request with multiple result as condition

[Alx J]

It's a system that classified a element. that the user will add and remove some criteria/information

exemple (not case...to hard to explain the real one..this is a simple simulation.)

we evaluate a car
for now i can definy the car like this
ID varName Value idCar
1 Door 4 0001
2 Color Blue 0001
3 Engine V6 0001

By maybe next week they wiil ask to add Number of Seat and remove engine type
The client frequently modify the criteria of evaluation.
And, as bonus, the criteria change if is a car, a moto or a truck


For now, my plan B is a mixed solution. 1 table for a couple off fixed variable et one table for 'im not sure' variable

By of course, i'm not a database architect so i'm here to lean new and better way to do this job


Of course, thank for your help and feedback

ALX