Re: SQL, related records (quotes)
From: Stefan Rybacki <stefan.rybacki_at_gmx.net>
Date: Fri, 24 Jun 2005 18:04:52 +0200
Message-ID: <3i2p94Fjf4r7U5_at_individual.net>
Date: Fri, 24 Jun 2005 18:04:52 +0200
Message-ID: <3i2p94Fjf4r7U5_at_individual.net>
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.
Regards
Stefan
Received on Fri Jun 24 2005 - 18:04:52 CEST