Avanceret join (4 join i en sætning)

Hej

Jeg skal have lavet disse 2 recordset om til 1 recordset, altså så oplysningerne hentes i et hug:

strSQL = "SELECT CAT_ID FROM FORUM_CATEGORY INNER JOIN FORUM_GROUPS ON FORUM_CATEGORY.CAT_ID = FORUM_GROUPS.GROUP_CATID WHERE FORUM_GROUPS.GROUP_ID = 6 AND FORUM_CATEGORY.CAT_ID <> 41"
            set rsLetterbox1 = dataConn.execute(strSQL)
   
            do while not (rsLetterbox1.bof or rsLetterbox1.eof)
                strSQL = "SELECT FORUM_FORUM.FORUM_ID FROM FORUM_FORUM INNER JOIN FORUM_MODERATOR ON FORUM_FORUM.FORUM_ID = FORUM_MODERATOR.FORUM_ID WHERE FORUM_MODERATOR.MEMBER_ID = " & RS("Member_ID") & " AND FORUM_FORUM.F_STATUS = 1 AND FORUM_FORUM.CAT_ID = " & rsLetterbox1("CAT_ID")
                set rsLetterbox2 = dataConn.execute(strSQL)
                if not (rsLetterbox2.bof or rsLetterbox2.eof) then
                    strGoto = "/forum/forum.asp?FORUM_ID=" & rsLetterbox2("FORUM_ID")
                    rsLetterbox1.close
                    rsLetterbox2.close
                    exit do
                end if
               
                rsLetterbox1.movenext
            loop