I have a XML file like this
<FIELDMAP>
<TABLE>
<NAME>LOCATIONS</NAME>
<FIELD>
<COLUMN>LOCATION_ID</COLUMN>
<TAG>CUSTOMER/ID</TAG>
<TYPE>VARCHAR</TYPE>
<LENGTH>80</LENGTH>
<ID>select nextval from sequence</ID>
</FIELD>
<FIELD>
<COLUMN>ADDRESS1</COLUMN>
<TAG>CUSTOMER/ADDRESS1</TAG>
<TYPE>VARCHAR</TYPE>
<LENGTH>80</LENGTH>
</FIELD>
</TABLE>
<TABLE>
<NAME>CONTACT</NAME>
<FIELD>
<COLUMN>LAST_NAME</COLUMN>
<TAG>CUSTOMER/LAST_NAME</TAG>
<TYPE>VARCHAR</TYPE>
<LENGTH>80</LENGTH>
<ID>select nextval from sequence</ID>
</FIELD>
<FIELD>
<COLUMN>FIRST_NAME</COLUMN>
<TAG>CUSTOMER/FIRST_NAME</TAG>
<TYPE>VARCHAR</TYPE>
<LENGTH>80</LENGTH>
</FIELD>
<FIELD>
<COLUMN>CREATED_BY</COLUMN>
<TAG>CUSTOMER/CREATED_BY</TAG>
<TYPE>VARCHAR</TYPE>
<LENGTH>80</LENGTH>
<ID>select nextval from sequence</ID>
</FIELD>
<FIELD>
</TABLE>
</FIELDMAP>
From this XML file I have to prepare a xsl sheet some thing like select LOCATIONS.LOCATION_ID,CONTACT.CUSTOMER/LAST_NAME from LOCATIONS,CONTACT where CONTACT.CUSTOMER/CREATED_BY=<xsl:value of select='CUSTOMER/CREATED_BY'/>
How to do this transformation .
Please let me know.
Regards
Savita.
