I have three tables:ACCOUNTS, WACCTS and CURRENCIES...
In ACCOUNTS i have a field CURR_CODE but i do not have CURR_ISO field
and
In WACCTS i have a field CURR_ISO
and
In CURRENCIES i have both CURR_CODE and CURR_ISO
The tables are represented in XML like this:
<ACCOUNTS>
<mappings>
<curr_code>1234</curr_code>
etc
</mappings>
<mappings>
etc
</mappings>
</ACCOUNTS>
<CURRENCIES>
<mappings>
<curr_code>1234</curr_code>
<curr_iso>12</curr_iso>
etc
</mappings>
<mappings>
etc
</mappings>
</CURRENCIES>
i want to write this select statement in XSLT:
"Select CURR_ISO from CURRENCIES where CURR_CODE(in
ACCOUNTS)=CURR_CODE(in
CURRENCIES)"
AND THE OUTPUT OF THIS SELECT STATEMET I NEED TO PUT IT IN THE CURR_ISO OF
WACCTS
i am using the ACCOUNTS table as the xml input to the saxon...
The WACCTS xml document is my output.(i.e i get the WACCTS xml document from
the saxon and fill in the WACCTS table).
THX...
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list