[thelist] SQL query execution order

[rudy]

it would help if i could cut & paste without making so many errors

try this --

        FROM responses
  INNER JOIN (
             form_lookup
  INNER JOIN questions
          ON form_lookup.questionid = questions.questionid
         AND form_lookup.formid = @formid
         AND ( questions.questionnumber BETWEEN @num1 AND @num2
           AND questions.status = 1 )
             )
          ON responses.questionid = form_lookup.questionid
       WHERE userid IN
              ( SELECT userid FROM usergroup_users
                 WHERE usergroupid = @usergroupid )


rudy