Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Is there any technical person (VB & ACCESS) RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
     

    Is there any technical person

    if yes , Please help me its urgent.

    I have a table named "reg_events"

    in that i have two columns

    stud_id        events

    adit001         x-linx

    adit001        x-treme-warz

    adit001        x-torque

    ait002          x-torque

    ait002         x-treme-warz

    ait002         x-quiz-it

    ldrp001       x-torque

    .....                .....

    I m not able to retrive the stud_id of students who has registered for the events "x-treme-warz" and " x-torque".

    I have used the query "SELECT DISTINCT r.stud_id
    FROM reg_events AS r  WHERE r.events='x-treme-warz' and  'x-torque'     "

    the output obtained is ID of students who has participated in both events or only one event.

    I want the output as ID of students who has participated in both the events only.

    Please can any one help me......

    Thursday, March 8, 2007 4:22 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    That was a good question. I tried it many times.. But in vain.. Wil surely find some solution..

    I think the solution could be giving r.events like 'x-treme-warz' and  r.events like 'x-torque'..

    Friday, March 9, 2007 11:01 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    hey venkat,

    thank u for your reply.

    what i think is like will not work because I want distinct Stud_ID's

    Friday, March 9, 2007 5:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    hi venkat.... they asking in vb & access but ur saying in orcale and sql server command na...
    Friday, March 9, 2007 6:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    any one tried, please help...

    i think it m8 be same in oracle as well as access

    Sunday, March 11, 2007 7:31 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    the query remains same for both access and oracle.
    Monday, March 12, 2007 6:01 PM