|
Posted by John Bell on 10/01/05 18:22
Hi
If your ranges do not overlap then you should be able to cope with the query
I posted use c.my_id as the chains identifier as your orig_id was NULL or
the first entry.
John
"Thomas R. Hummel" <tom_hummel@hotmail.com> wrote in message
news:1128177507.802681.287910@f14g2000cwb.googlegroups.com...
> John Bell wrote:
>> Hi Thomas
>>
>> This gives you the results you wanted, but if you have more than one
>> chain
>> you will need a means of identifying them.
>
> Unfortunately, that's perhaps the biggest problem that I have. The only
> way to determine that a row in Copy_To or Copy_From is in a chain with
> another row is to follow the links. Once the rows are in the Chain
> table the Orig_ID can be used to distinguish all chains.
>
> I'll play around with the code that you included and see if I can get
> something worked out. Unfortunately, I think that I'm going to be stuck
> recursing through the chains to link them together.
>
> Thanks for all of your help!
>
> -Tom.
>
Navigation:
[Reply to this message]
|