I am trying to join 3 SQL tables together in an XSLT string. I have successfully joined 2 tables together using INNER JOIN and the like, but I have a slightly more complicated need that requires 3 joined tables.

The 3 tables are:

1) web_YouTube, which contains each video's information.

2) web_Programs, which contains each academic program's info (college, seminary, etc)

3) web_Programs_Videos, which is a 'switchboard' table that pulls together program ID's from web_Programs and video ID's from web_YouTube. I have academic program pages that displays videos according to this combination of IDs.

Here's the tricky part:

I am building "study area" pages that list the different levels of study available for each course area (whether or not you can take a minor, AA, BA, MA, MDiv, or Certificate in any study area, such as Biblical Studies, Humanities, Geography, English, etc.). These study area pages will link to the program pages, where program-specific info will be listed.

All of this area-of-study info is held in a table called web_Areas_of_Study, The web_Programs table links each academic program to an area of study by the area of study's ID number from web_Areas_of_Study.

The trouble I am having is that I am trying to access the program_StudyArea from web_Programs so that I can display videos from web_YouTube that pertain to the area of study.

I could simplify things by creating another switchboard table that lists videos by study area rather than by program, but I am hoping to avoid this so that the people managing the content don't have to upkeep two different video lists.

So, if you're still with me, how do I go about joining web_YouTube, web_Programs_Videos, and web_Programs together? Below is the JOIN I attempted, but so far no luck. I'm still a novice with XSLT, so any input will be most gratefully received.

    <xsl:variable name = "studyAreaVideos" select="SQL:GetDataSet('DBname', concat(
      'SELECT YouTubeID, VideoDisplay, VideoPosted, YouTubeCode, progvid_ProgramID, progvid_VideoID,
              progvid_Sort, program_Id, program_StudyArea
      
      FROM web_YouTube
      
      INNER JOIN web_Programs_Videos
      ON web_YouTube.YouTubeID = web_Program_Videos.progvid_VideoIDramID
      
      JOIN web_Programs
      ON web_Programs.program_Id = web_Programs_Videos.progvid_ProgramID
      
      WHERE web_Programs.program_StudyArea = ', $studyAreaVideosID), 
      
      'studyAreaVideos')"/> 

 <div class = "videodisplay">
      <xsl:for-each select="$studyAreaVideos//studyAreaVideos">
          <xsl:sort select="progvid_Sort" order="ascending" />

            <div>
                <xsl:attribute name="id">progvid_tab<xsl:value-of select="YouTubeID"/></xsl:attribute>
                <xsl:attribute name="class">progvid_tab_content</xsl:attribute>
                <object>
                    <xsl:attribute name="type">application/x-shockwave-flash</xsl:attribute>
                    <xsl:attribute name="data"><![CDATA[http://www.youtube.com/]]><xsl:value-of select="YouTubeCode"/><![CDATA[?fs=1&hl=en_US&rel=0&autohide=1]]></xsl:attribute>
                    <xsl:attribute name="width">680</xsl:attribute>
                  <xsl:attribute name="height">384</xsl:attribute>
                    <param>
                        <xsl:attribute name="name">movie</xsl:attribute>
                        <xsl:attribute name="value"><![CDATA[http://www.youtube.com/]]><xsl:value-of select="YouTubeCode"/><![CDATA[?fs=1&hl=en_US&rel=0&autohide=1]]></xsl:attribute>
                    </param>
                    <param>
                      <xsl:attribute name="name">allowFullScreen</xsl:attribute>
                      <xsl:attribute name="value">true</xsl:attribute>
                    </param>
                </object>
            </div><!-- end of tab -->
      </xsl:for-each>
      </div><!-- videodisplay -->