Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2004
    Location
    L, Schleswig-Holstein, Germany
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query problem - inside (2003)

    Hi everyone,

    after a long abstinence it's me again having a question.

    Datastructure (shortened):

    tblSchools
    [ID] *
    [School]

    tbljoinSchoolsandParticipation
    [ID] *
    [Year] *
    [Participation] (Y/N)

    Now I want to exclude all schools which have ever participated with a query.

    My SQL Looks like this:
    SELECT tblSchools.*, tblSchools.Country, joinSchoolsParticipation.Participation
    FROM joinSchoolsParticipation INNER JOIN tblSchools ON joinSchoolsParticipation.ID = tblSchools.ID
    WHERE (((tblSchools.Country)="Germany") AND ((joinSchoolsParticipation.Participation)=False));

    What this does is: return nothing, because for those schools which have NEVER participated there is no record in 'tbljoinSchoolsandParticipation' - meaning that Access can't return anything.
    So how do I do this?

    I hope you got my point, else I can try to explain some more.

    Dennis

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query problem - inside (2003)

    Try replacing INNER by RIGHT.

  3. #3
    2 Star Lounger
    Join Date
    Jun 2004
    Location
    L, Schleswig-Holstein, Germany
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query problem - inside (2003)

    Yeah forgot about RIGHT and LEFT joins, but it just doesn't do the trick. Still returning no records.
    --------EDIT---------

    Does work. I just had to put a Is NULL in there instead of false. THanks

Posting Permissions

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