title: how do i get hierarchy of data from two different tables?
body: <p>I have two tables <strong>TwitterStatus</strong> and <strong>twitterstatusDetails</strong>,</p>
  <p>I have data respectively in following manner.</p>
  <p><img src="https://i.stack.imgur.com/Qd79l.png" alt="enter image description here" /></p>
  <p>Here as given in twitterstatus table 4th record with the <strong>ts_StatusID</strong> &quot;587573444633427968&quot; is parent of twitterstatus_Details table 3rd record, which having td_inReplyTostatusID value is &quot;587573444633427968&quot;, for next record td_StatusID of recent child record is parent of twitterstatus table having that child ts_StatusID value in ts_InreplytoStatusID field, so like that it is the hierarchy, so</p>
  <h3>how can I get the records from both the tables based on child parent relationship?</h3>
  <p>still any concern then please ask in comment.</p>
  <p>Thank you.</p>