Need urgent help

10 pts.
Tags:
Query
Query Design
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 Now, 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... Sanket

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Need urgent help   If you need urgent help, you should put a useful subject on your question. Those who read the subject cannot tell if your question fits with their knowledge or not. Many will just skip a question that doesn't identify itself.   In table 1 is as shown below   "Below"? Below what?   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   I can't make any sense out of that.   Now, I want to map risk level to table 1 based on combinations given in table 2.   It might be easy, but I can't determine anything about the structure of either table. I don't know how many columns are in the tables, how the columns are defined, which columns hold what values.   You need to provide a much better description of the tables and columns. Please try again.   Tom
    125,585 pointsBadges:
    report
  • ToddN2000
    I agree with Tom we need a lot more clarification if we are going to make an attempt to solve the issue.  Are you referencing 4 table in your example? What do you want you final data to look like ? Are there more than 1 possible join value ? ... We need more details..
    15,605 pointsBadges:
    report
  • carlosdl
    To have better chances of a useful (and possibly quick) answer, you should:  -Use a well thought question title (as mentioned by Tom) -Put an amount of effort that is proportional to the importance of the problem for you, when describing your problem and wording your question -Provide your data structures as clearly as possible -Provide some example data, along with the results you would expect from it. -Provide information about the database platform you are using, in case there is a non-standard but easier way to solve it on that specific platform. -Tag your question appropriately
    70,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following