RE: Join XMLs with XLST with ralative data

Hi,

> I am using join.xslt 
> <xsl:stylesheet version="1.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
> <xsl:key name="rows-bstkcode" match="bstkcode"
> use="bstkcode" />

The key should be

  <xsl:key name="rows-bstkcode" match="name" use="bstkcode" />

>   <xsl:for-each select="$x_22/STKAVAILABLE/STKMAST">

If you only want the STKCODE 31, i.e. the first one, this should be

  <xsl:for-each select="$x_22/STKAVAILABLE/STKMAST[1]">

>       <xsl:for-each select="$buy22">
>         <xsl:copy-of select="key('rows-bstkcode',
> $STKCODE)
>         				/*[name() != 'bstkcode']" />
>         				
>       </xsl:for-each>

This should be e.g.

  <xsl:for-each select="$buy22">
    <xsl:for-each select="key('rows-bstkcode', $STKCODE)">
      <xsl:copy>
        <xsl:copy-of select="@id" />
      </xsl:copy>
    </xsl:for-each>

Because what you had would output 

  <tran>
    <STKMAST Alias="01" STKCODE="31">
      <address/>
      <address/>
    </STKMAST>
  </tran>

Cheers,

Jarno - Claire Voyant: Love the Giver (remix by Eskil Simonsson of Covenant)

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list