I'm migrating a exam module to DNN, but now I run into a problem with inner join statements.
the existing Stored Procedure is:

CREATE PROCEDURE Exam_getUsersOfExam
(
    @examId INT
)
AS

SELECT DISTINCT Users.UserID, Users.FirstName, Users.LastName, Departments.Name As GroupName
FROM Exam_ExamQuestion Inner Join (Exam_Result Inner Join (Users Inner Join Departments On Users.DepartmentId = Departments.DepartmentId) On Exam_Result.UserId = Users.UserID) On Exam_ExamQuestion.ExamQuestionId = Exam_Result.ExamQuestionId
WHERE Exam_ExamQuestion.ExamId = @examId
Order by Users.FirstName asc, Users.LastName asc

GO

now is my problem that my DNN installation hasn't got an department table, so I have to get rid off that part of the SPROC.

Can anyone help me with this problem?

Many thanks,

I really couldn't find a problem with your stored proc. It should work and typically not having a table available will generate a warning rather than an out right error. What error are you getting?

I also suggest trying to move the "on" statements next to their respective join. I also recommend formatting your queries as I have below, this allows for easier debugging because if you need to eliminate a join you can do so typically by placing "--" infront of the join you wish to eliminate by commenting it out.

CREATE PROCEDURE Exam_getUsersOfExam
(
    @examId INT
)
AS

SELECT DISTINCT Users.UserID, Users.FirstName, Users.LastName, Departments.Name As GroupName
FROM Exam_ExamQuestion 
     INNER JOIN Exam_Result ON Exam_ExamQuestion.ExamQuestionId = Exam_Result.ExamQuestionId 
     INNER JOIN Users ON Exam_Result.UserId = Users.UserID
     INNER JOIN Departments ON Users.DepartmentId = Departments.DepartmentId
WHERE Exam_ExamQuestion.ExamId = @examId
ORDER BY Users.FirstName ASC, Users.LastName ASC

GO

Where is your departments table?  Is it in another database?  As long as it's on the same server, you can access that table using...

SELECT DISTINCT Users.UserID, Users.FirstName, Users.LastName, Departments.Name As GroupName
FROM Exam_ExamQuestion 
     INNER JOIN Exam_Result ON Exam_ExamQuestion.ExamQuestionId = Exam_Result.ExamQuestionId 
     INNER JOIN Users ON Exam_Result.UserId = Users.UserID
     INNER JOIN databasename.dbo.Departments ON Users.DepartmentId = Departments.DepartmentId
WHERE Exam_ExamQuestion.ExamId = @examId
ORDER BY Users.FirstName ASC, Users.LastName ASC