#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    2
    Rep Power
    0

    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
    Input 1-((AB,1,CD,2),R)
    Input 2-((AB,1,CD,2,PQ,4),R)

    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?
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2010
    Location
    Katy, Texas
    Posts
    495
    Rep Power
    199
    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...
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    2
    Rep Power
    0

IMN logo majestic logo threadwatch logo seochat tools logo