SQL statment help!!!

Results 1 to 3 of 3

Thread: SQL statment help!!!

  1. #1
    Sven SQL server Guest

    Default SQL statment help!!!

    im making a cross join question on my sql server between 2 tables, without succes...<BR><BR>instead of writing my sql statment i think its simpler to write what i want to achive..<BR><BR>I have a login table containing all users on my site, and i have another table containing answers on diffrent surveys, now i want to get all those peopel that hasnt answer to one specified survey..<BR><BR>When answering the survey the table is updated with the survey ID and the login name of the participant. <BR><BR>does this make sence ? <BR>plz help me out! if you need more info.. dont hesitate to reply this message !

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL statment help!!!

    select * from users <BR>where userid not in (select userid from surveys)

  3. #3
    no need for a name Guest

    Default RE: SQL statment help!!!

    tack !<BR><BR><BR>skall testa om det fungerar =D!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts