hi all,

win xp, excel 2003.

i would like to ask if i can do any relational query on an xml data
source inside excel.

say, i have an xml document: employer.xml

<employerList>
 <employer>
   <Name>Guy1</Name>
   <Department>Marketing</Deparment>
 </employer>
 <employer>
   <Name>Guy2</Name>
   <Department>Finance</Deparment>
 </employer>
 <employer>
   <Name>Guy3</Name>
   <Department>Accounting</Deparment>
 </employer>
</employerList>

and i also have this xml document: departmentGroup.xml

<DepartmentGroup>
 <Deparment>Marketing</Deparment>
 <Deparment>Accounting</Deparment>
</DeparmentGroup>

Is it possible for me to make queries on these two xml data sources
(something similar to SQL or XQuery) to generate the following?

select <name> from employer.xml
 where <deparment> in employer.xml = <department> in
departmentGroup.xml

so that i can get:
Guy1
Guy3

??? it is certain that i must work with XML format. or, is there any
similar method to do query on XML??

Thanks so much in advance,
isa