Need help for SQL

From: Á¤¿µ¼® <illudus2_at_kornet.net>
Date: Sun, 26 Aug 2001 13:59:06 +0900
Message-ID: <9m9uud$kjc$1@news2.kornet.net>

Hello!
I need a SQL for following with Oracle

I have 3 tables

1) Student with StudentID as PK
2) Subject with subjectID as PK
3) StudentSubject with StudentID,SubjectID as PK'S.

Data Example:
Student table
SID Name

---

1     James
2     Smith

Subject table
SUBID Subject

---

1     Math
2     English
3     Science

StudentSubject table
SID SUBID Marks

---

1   1     90
2   1     85

I Want the final result like this
The information I know is SID = 1

SID Subject Marks

---

James Math 90
James English NULL(or Nothing)
Robert Science NULL(Nothing)

pls help!! Received on Sat Aug 25 2001 - 23:59:06 CDT