RE: problem with keys and Meunchian method

> From: mark_fletcher@xxxxxxxxxxxxxx
[mailto:mark_fletcher@xxxxxxxxxxxxxx]
>
> I'm having a problem pulling distinct nodes out of some xml with
duplicate
> values at multiple levels.  In all cases, I want to get the data from
the
> last node of a set that shares duplicate values.  (This xml will be in
a
> file that gets appended to multiple times.  So I can assume that the
last
> tags are the most current.)
>
> In the xml below, what I'm trying to do is get a list of distinct
> book/code
> values from the last prodline where name=PL1.  I can successfully get
the
> prodline using this select statement:
>

Can a book with a given name have different code values?  Can a book
with a given code have different names?  If the answer is "no" to both,
things will be easier.

Cheers,

Tom P