Home -> Usenet -> comp.databases.theory -> SQL, related records (quotes)

SQL, related records (quotes)

From: <timpea_at_gmail.com>
Date: 24 Jun 2005 08:56:01 -0700
Message-ID: <1119628561.458253.110450_at_g44g2000cwa.googlegroups.com> 





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 - 17:56:01 CEST












Original text of this message