title: (SQL Query, Email) Need a query to find "thread items" based on a field in the same table
body: <p>I'm looking to perform a somewhat complex SQL Query and I'm having a bit of a time wrapping my head around what I need to do.  I can't seem to figure out a JOIN that will work for my situation.</p>
  
  <p>Basically, my issue is that I have a table of EMAIL objects with various headers separated out and I'm trying to implement THREADING.  In my estimation, I need to do the following:</p>
  
  <p>1) Select all items that have no "IN-REF-TO" value -- as those are likely thread starters</p>
  
  <p>2) Select all items (from the same table) that have any of the previously found "REF-NUM"s inside their "IN-REF-TO" fields</p>
  
  <p>3) order by date ... I think I can handle this part  =P</p>
  
  <p>I'd like to have all data returned in a single recordset, but I'm completely open to suggestions.  Can you loop with SQL?  If anyone feels that this isn't the way to go about it then, by all means, please suggest some other mechanism.  For the record, I didn't design the database and there is very little chance that the structure will be changed in the next 6 mths or so.</p>