database SQL problem

[virusdude]

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