Re: Can this be done in one select

[Paul DuBois]

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.