This should be pretty close:

select
s.student_name,
q.student_id,
q.software_id,
q.software_description
from
(select
t.student_id,
o.software_id,
o.software_Description
from
student_software t,
software o
where o.software_id=t.software_id (+) and
t.software_id is null) q,
student s
where q.student_id=t.student_id


-----Original Message-----
From: Brett N Exton
[mailto:oracledba-ezmlmshield-x46347688.[Email address protected]
Sent: Thursday, March 30, 2006 4:21 AM
To: LazyDBA Discussion
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


-----------------------------------------
CONFIDENTIALITY NOTICE

This message and any attachments are from the NAIC and are intended
only for the addressee. Information contained herein is
confidential, and may be privileged or exempt from disclosure
pursuant to applicable federal or state law. This message is not
intended as a waiver of the confidential, privileged or exempted
status of the information transmitted. Unauthorized forwarding,
printing, copying, distribution or use of such information is
strictly prohibited and may be unlawful. If you are not the
addressee, please promptly delete this message and notify the
sender of the delivery error by e-mail or by calling the NAIC Help
Desk at (816)783-8500.


Oracle LazyDBA home page