preparing a XSL sheet

[Savita <sa...@india.hp.com>]

Hi all,

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.