Yes, thank you for your work Vlad. What appears to happen is that in some cases, I loose the master record, in others I get duplicates -- niether of which is ok.

>Hi!
>
>Did you tried both queries as I proposed? See which one is better for you.
>
>>My usage of the sample code produced the same results as my own code, except there were missing master records :-(
>>
>>Let me show some sample data, maybe we can get at it that way.
>>
>>master.id, name
>>1, Todd
>>2, Vlad
>>3, Sergey
>>crossref.id, crossref.id2
>>1,5
>>1,6
>>1,7
>>child.id2, child.location, child.altid
>>5,BILL,A
>>6,MAIN,B
>>7,WORK,C
>>
>>What I want in my result set is:
>>master.id, master.name, master.myfield
>>1, Todd, B
>>