List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 7 2001 1:57am
Subject:Re: Can this be done in one select
View as plain text  
At 1:51 AM +0000 11/7/01, Mark Worsdall wrote:
>Hi,
>
>I have 3 tables
>
>TABLE                   columns
>student                 id and name
>disability              id and name
>studentDisability       disability_id and student_id
>
>
>I want to extract all students who do not have a disability assigned 
>to them in the join table.
>
>SELECT student.name, student.id FROM student WHERE

... FROM student LEFT JOIN studentDisability
     WHERE studentDisability.student_id IS NULL

>
>and that is where I get stuck, can I put a select in the where 
>section to achieve my goal?
>
>
>M.

Thread
.NET and MySQLMichael S Kilaras5 Nov
  • Can this be done in one selectMark Worsdall7 Nov
    • Re: Can this be done in one selectPaul DuBois7 Nov
      • Re: Can this be done in one selectMark Worsdall7 Nov
        • Re: Can this be done in one selectPaul DuBois7 Nov
          • Re: Can this be done in one selectMark Worsdall7 Nov
      • Re: Can this be done in one selectMark Worsdall7 Nov