Re: SQL, related records (quotes)
From: Jan Hidders <jan.hidders_at_REMOVETHIS.pandora.be>
Date: Fri, 24 Jun 2005 20:45:55 GMT
Message-ID: <7i_ue.129098$sd.7126154_at_phobos.telenet-ops.be>
>> Hi,
>>
>> I have a website that users can request quotes, and a user may also
>> make a new quote that links to a previous quote.
>>
>> QuoteNo PreviousQuoteNo
>> 1
>> 2
>> 3 1
>> 4 3
>> 5 4
>>
>> If i request quoteNo 3 i want to have a list of all the related quotes.
>>
>>
>> RelQuote
>> 1
>> 3
>> 4
>> 5
>>
>> Is this possible with a SQL statement? or would i be best doing a loop
>> in asp and many requests?
>> Thanks Tim Pearson
>>
>
> Try the nested sets model.
Date: Fri, 24 Jun 2005 20:45:55 GMT
Message-ID: <7i_ue.129098$sd.7126154_at_phobos.telenet-ops.be>
Stefan Rybacki wrote:
> timpea_at_gmail.com wrote: >
>> Hi,
>>
>> I have a website that users can request quotes, and a user may also
>> make a new quote that links to a previous quote.
>>
>> QuoteNo PreviousQuoteNo
>> 1
>> 2
>> 3 1
>> 4 3
>> 5 4
>>
>> If i request quoteNo 3 i want to have a list of all the related quotes.
>>
>>
>> RelQuote
>> 1
>> 3
>> 4
>> 5
>>
>> Is this possible with a SQL statement? or would i be best doing a loop
>> in asp and many requests?
>> Thanks Tim Pearson
>>
>
> Try the nested sets model.
Are you sure the relation describes always a tree?
- Jan Hidders