What is query to map data by combining multiple columns in different table
I have two tables named table 1 and table 2 respt..
In table 1 is as shown below
User Role AP.A AP.B AP.C AP.D High Low Medium
Sanket Admin AP.A AP.B AP.D
Abhi Man AP.B AP.C
Sank Emp AP.A AP.C AP.D
And I have one more table as shown below :
Group1 Group2 Risk_Level
AP.A AP.B High
AP.C AP.D High
AP.A AP.C Low
AP.B AP.D Medium
I want to map risk level to table 1 based on combinations given in table 2.
If risk level is "High" then i have to put "Yes" under column "High" in table 1.
Could any one of you please advise me...
thanx in advance...
October 4, 2012 7:40 AM
October 4, 2012 11:56 AM