It worked!!
I am using Survey Module and would like to Create a report that can be viewed by users. Here is the SQL syntax that I would like to share with others. it maybe useful for someone else.

SELECT DISTINCT Users.DisplayName, Surveys.ViewOrder, Surveys.Question, SurveyOptions.OptionName
FROM         Surveys INNER JOIN
                      SurveyOptions ON Surveys.SurveyID = SurveyOptions.SurveyID INNER JOIN
                      SurveyResults ON SurveyOptions.SurveyOptionID = SurveyResults.SurveyOptionID INNER JOIN
                      Users ON SurveyResults.UserID = Users.UserID INNER JOIN
                      UserProfile ON Users.UserID = UserProfile.UserID
WHERE     (UserProfile.PropertyDefinitionID = 45) AND (NOT (Surveys.ViewOrder IN (1, 9))) AND (Users.UserID IN
                          (SELECT DISTINCT @UserID
                            FROM  Users ))

Many thanks again.