Home » SQL & PL/SQL » SQL & PL/SQL » Check for view?
Check for view? [message #208778] Tue, 12 December 2006 04:19 Go to next message
Messages: 1
Registered: December 2006
Location: Sweden
Junior Member

I would like to add a coloum for QualForGrad witch checks that the student have what is required for graduation.
This is the view where i put all the tables together.

CREATE VIEW PathToGraduation AS
SELECT student.persID, credTaken, branchCred, MathCredTaken, ResearchCredTaken, SeminarsTaken, BmansLeft, PmansLeft
FROM Student, NrCredits, BranchSpec, MathCredits, ResearchCredits, SeminarCount, BmanToRead, PManToRead
WHERE student.persID = nrCredits.persID AND
student.persID = BranchSpec.persID AND
student.persID = MathCredits.persID AND
student.persID = ResearchCredits.persID AND
student.persID = SeminarCount.persID AND
student.persID = BmanToRead.persID AND
student.persID = PmanToRead.persID;
Re: Check for view? [message #208790 is a reply to message #208778] Tue, 12 December 2006 04:46 Go to previous message
Messages: 381
Registered: September 2006
Location: UK
Senior Member
And how exactly are we supposed to help you with this ?
Previous Topic: SELECT statement with subtotal and total & Rollup
Next Topic: Help needed
Goto Forum:

Current Time: Sun Oct 23 21:13:02 CDT 2016

Total time taken to generate the page: 0.08741 seconds