Like:

select software_description from software s
where not exists
(select 1 from student_software ss
where ss.software_id = s.software_id
and student_id = 1)
/

?


> ----- Original Message -----
> From: "Brett N Exton "
> <oracledba-ezmlmshield-x46347688.[Email address protected]
> To: "LazyDBA Discussion" <[Email address protected]
> Sent: Thursday, March 30, 2006 11:21 AM
> Subject: SQL - Help !
>
>
>> Please help me with this brain teaser !
>>
>> I have 3 tables as below:
>>
>> TABLE: SOFTWARE
>> SOFTWARE_ID
>> SOFTWARE_DESCRIPTION
>>
>> TABLE: STUDENT
>> STUDENT_ID
>> STUDENT_NAME
>>
>> TABLE: STUDENT_SOFTWARE
>> STUDENT_ID
>> SOFTWARE_ID
>>
>> The requirement is an SQL statement which, for a specified student_id,
>> will
>> list all of the software from the SOFTWARE table which the student DOES
>> NOT
>> have.
>>
>> Brett
>>
>>
>> ________________________________________________________________________
>> This e-mail and any attachments transmitted with it represents the
>> views of the individual(s) who sent them and should not be regarded
>> as the official view of Bridgend County Borough Council. The contents
>> are confidential and intended solely for the use of the addressee. If
>> you have received it in error, please inform the system administrator
>> on (+44) 01656 642111.
>>
>> This e-mail and any attachments have been scanned with 'MessageLabs
>> SkyScan' - http://www.messagelabs.com/
>>
>> ________________________________________________________________________
>> Maer'r e-bost hwn ac unrhyw atodiadau a drosglwddir gydag ef yn
>> cynrychioli
>> safbwyntiau'r unigolyn (unigolion) a'u hanfonodd ac ni ddylid eu
>> hystyried fel
>> safbwynt swyddogol Cyngor Bwrdeistref Sirol Pen-y-bont ar Ogwr. Mae'r
>> cynnwy
>> syn gyfrinachol ac wedi'i fwriadu at ddefnydd y person y'i cyfeiriwyd ato
>> yn
>> unig. Os ydych wedi ei dderbyn mewn camgymeriad, rhowch wybod i
>> weinyddwry system ar (+44) 01656 642111.
>>
>> Mae'r e-bost hwn ac unrhyw atodiadau wedi cael eu sganio gyda
>> 'MessageLabs SkyScan' - http://www.messagelabs.com/
>> ________________________________________________________________________
>>
>>
>> --------
>> website: http://www.LazyDBA.com
>> Please don't reply to RTFM questions
>> Oracle documentation is here: http://tahiti.oracle.com
>> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>> To subscribe: see http://www.lazydba.com
>> By using this list you agree to these
>> terms:http://www.lazydba.com/legal.html
>>
>


Oracle LazyDBA home page