How to JOIN more than two tables?
try this


SELECT [Subject] , [Type], MarksObtd 
  FROM [Marks_Table] 
  INNER JOIN [Subjects_Table] 
  ON [Marks_Table].SubjectCode = [Subjects_Table].SubjectCode 
  INNER JOIN [Types_Table] 
  ON [Marks_Table].TypeID = [Types_Table].TypeID


As james added comment, I think it is a simple join and you need to change [TypeID] in select clause to [Type]