database SQL problem[ SOLVED ]
i have 4 tables in my database
Applicant (appNum(PK), studentId, title, lastName, firstName)
Student(studentId (PK), appNum(FK), courseCode)
StudSub(studentId(FK), subCode(FK), enrolment, grade, semester)
Subject(subCode(PK), subName, Credit Points)
I need to retrieve the following information from the 4 tables
i need the studentid, title, lastName, firstName, subcode, subName. enrolment and grade.
i have tried some sql statements that are giving me the records but it is also repeating the studentid, name, title first name and lastname for all the subcode.
i only want the student id, title, lastname and firstname to appear only once.
can anyone help plz
Last edited by virusdude; 04-19-2004 at 02:25 AM.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL