July 23rd, 2013, 01:07 AM
Need help in query development for the below scenario
I have table structure as below
FIELD1 FIELD2 FIELD3 FIELD4
ID001 AB 1 R
ID001 CD 2 R
ID002 AB 1 R
ID002 CD 3 R
ID002 EF 4 R
ID003 AB 1 R
ID003 CD 2 R
ID003 PQ 4 R
ID004 PQ 1 R
ID004 RS 2 R
Input I am getting from the other resource is like this
For this I should get field1 as the output.
For input 1, it should return ID001
For input 2, it should return ID003.
Can anybody help me out for this?
July 24th, 2013, 04:55 PM
Please ask a comprehensible question.
Tables have columns, not fields.
What is "the other resource"? For that matter, what is the primary resource you are referencing?
Your input makes no sense. Input for what? Input to what?
Your whole post makes no sense. Sorry I can't help, but you will have to actually post a question other than "can you help?".
Do you agree? Disagree? And remember, it's all about the reputation power...
July 25th, 2013, 07:43 AM