Hi there!
Ive been working on my relational schema for a while now and just recently managed to implement it. I wanted experiment a little with it so ive decided to produce a report displaying relevant information. At the moment my schema only consists of 3 tables : a 'student' table, a 'course' table and a student 'next-of-kin' table. The pk for student is named 'studentNo', the same goes for 'course' and 'next-of-kin' ('courseNo', 'next_of_kinNo'). 10 entries have been made so far for both 'student' and 'next_of_kin'.
The report i intend to produce will need to display a list of students studying 1 common course (Business Studies, courseNo : '12885545'). The report should be ordered by studentNo.
This is what i have already come up with:
--set echo off
--set pagesize 24
--set feedback off
--set linesize 78
col A format 99999999 heading 'Student No'
col B format A15 heading 'Student Name'
col C format A15 heading 'Course Name'
col D format 99999999 'Course No'
col E format A10 heading 'Next-of-Kin'
break ON A skip 1 ON B
TTitle 'Business Studies 1 Option BT300'
BTitle 'Prepared By : Richard Stroud / 20527796'
SELECT StudentNo A,
fName || ' ' || lName B,
title C,
courseNo D,
fName || ' ' || lName E,
FROM student A, course B, next_of_kin C
WHERE B.courseNo = 12885545
ORDER BY studentNo
--clear columns
--TTitle off
--BTitle off
--set feedback on
--set pagesize 24
--clear breaks
When i execute the above i am prompted with an 'unknown column option "Course" error message.
I will greatly appreciate any help in regards to this issue
~ Richard
Last edited by peter_budo; Nov 18th, 2008 at 6:54 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.