By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,635 Members | 2,188 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,635 IT Pros & Developers. It's quick & easy.

SQL Linked Records (Quotes)

P: n/a
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

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.