Evaluate SQL expr in column data

Database
Fan

Evaluate SQL expr in column data

I have 2 tables as follows -

Table t1 has list of users and their age
Table t2 has list of rules, variable and rule_formula

For all users in t1, I need to evaluate the rule_formula (which is a mathematical expression involving t1.age and t2.variable) for each rule.

Any suggestions on how this can be achieved?
1 REPLY
Enthusiast

Re: Evaluate SQL expr in column data

Can you plz post some sample data from both tables and expected o/p?