I have a table w/ quotes. Each quote has a quote_id (which is the table key). Each quote also has quote_member_id (the id of the site member who said the quote). _Some_ of the quotes are not "stand alone" -- they only make sense as part of a series of quotes (a conversation or statement/reply). Any quote that is part of a series of quotes also has a quote_thread_id to specify that said quotes are grouped together. (With me so far?)
I want to be able to retrieve all of the quotes by a specific member. If they have any quotes that are part of a thread, I also need to retreive quotes by other members with the same quote_thread_id (so that you can read the original quote, in context). Is there any way to do this in a single query? I thought I might do this with some sort of subselect, but the system I'm on has MySQL 4.013 -- and according to the MySQL web site, subselects are not supported until 4.1.0. (I have no control over the DB server version -- I am not the server admin. I _DO_ have the ability, howver, to redesign the table if that would make the query easier.) Any ideas? Thanks, Dave ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
