join xml documents?

[Danny Acuna]

I have two xml documents

<?xml version="1.0" standalone="yes"?><CodesFile><CatNumber><number>1</number><code>001</code></CatNumber><CatNumber><number>2</number><code>002</code></CatNumber><CatNumber

an

<?xml version="1.0" standalone="yes"?><NewDataSet><Table><Number_>1</Number_><category_name>Regular </category_name></Table><Table><Number_>2</Number_><category_name>Overtime</category_name></Table><Table></NewDataset

I need to get category_name from doc2 into doc1 as a child just like number and code. If these two documents were tables I would do it like this

select doc1.number, doc2.category_name, doc1.code from doc1 left join doc2 on doc1.number = doc2.number

How would I accomplish this in xml? Would I use XSLT

Thanks

Dann

[Sonu Kapoor]

1) load both xml in different xml documents.
2) store the needed nodes in an another xml doc.
3) use function importnode to import nodes from file1 to
file2.

hth.

Sonu
http://weblogs.asp.net/sonukapoor/

-----Original Message-----
I have two xml documents:

<?xml version="1.0" standalone="yes"?
<CodesFile><CatNumber><number>1</number><code>001</code></ CatNumber><CatNumber><number>2</number><code>002</code></Ca
tNumber><CatNumber>
and

<?xml version="1.0" standalone="yes"?
<NewDataSet><Table><Number_>1</Number_><category_name>Regu lar
</category_name></Table><Table><Number_>2</Number_><categor
y_name>Overtime</category_name></Table><Table></NewDataset>
I need to get category_name from doc2 into doc1 as a child just like number and code. If these two documents
were tables I would do it like this:
select doc1.number, doc2.category_name, doc1.code from doc1 left join doc2 on doc1.number = doc2.number_
How would I accomplish this in xml? Would I use XSLT?

Thanks,
Danny

.

[Sonu Kapoor]

1) load both xml in different xml documents.
2) store the needed nodes in an another xml doc.
3) use function importnode to import nodes from file1 to
file2.

hth.

Sonu
http://weblogs.asp.net/sonukapoor/

-----Original Message-----
I have two xml documents:

<?xml version="1.0" standalone="yes"?
<CodesFile><CatNumber><number>1</number><code>001</code></ CatNumber><CatNumber><number>2</number><code>002</code></Ca
tNumber><CatNumber>
and

<?xml version="1.0" standalone="yes"?
<NewDataSet><Table><Number_>1</Number_><category_name>Regu lar
</category_name></Table><Table><Number_>2</Number_><categor
y_name>Overtime</category_name></Table><Table></NewDataset>
I need to get category_name from doc2 into doc1 as a child just like number and code. If these two documents
were tables I would do it like this:
select doc1.number, doc2.category_name, doc1.code from doc1 left join doc2 on doc1.number = doc2.number_
How would I accomplish this in xml? Would I use XSLT?

Thanks,
Danny

.