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
lixen
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
Cthulhu
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 Dec 04 22:32:46 CST 2016

Total time taken to generate the page: 0.14697 seconds