xsl-list
[Top] [All Lists]

SQL SELECT statement in XSLT!

2003-08-05 23:34:59
hi,

I have three tables:ACCOUNTS, WACCTS and CURRENCIES...
In ACCOUNTS i have a field CURR_CODE
and
In WACCTS i have a field CURR_ISO

i want to write this select statement in XSLT:

"Select CURR_ISO from CURRENCIES where CURR_CODE(in ACCOUNTS)=CURR_CODE(in CURRENCIES)"
i am using the ACCOUNTS table as the xml input to the saxon...
Do i have to merge ACCOUNTS and CURRENCIES XML documents and use them as the input or what???

Thanks in advance...

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail


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



<Prev in Thread] Current Thread [Next in Thread>