[xquery-talk] xquery distinct-values

[Jane Doe]

First, please accept my apologies if this is the wrong place to post.

I have two xml files.

file1.xml has
<namelist><person>
<name>John</name>
<carids>1</carids>
<carids>3</carids>
<carids>4</carids>
</person></namelist>

file2.xml has
<carlist>
<car id='1'>
<style>sedan</style>
<car id='3'>
<style>coupe</style>
<car id='4'>
<style>sedan</style>
</carlist

I am trying to write an xquery that will return the names with more than 2 
of any style:

for $x in doc("file1.xml")/namelist/person
let $y := doc("file2.xml")/carlist/car[@id=$x/carids]
for $value in ($y/style)
where count($y/style[.=$value]) ge 2
order by ($x/name) descending
return <name>{data($x/name)}</name>

This returns the names of everyone with more than 2 of any style, but it 
returns that same name multiple times (in relation to the number of 
duplicate styles).

I hope it's not too confusing, and I appreciate any help you can give me.

Thanks,
D

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/