Re: SQL, related records (quotes)

Here is set of links (which seems to be kept up to date!)

http://troels.arvin.dk/db/rdbms/links/#hierarchical

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
Received on Fri Jun 24 2005 - 23:47:17 CEST