title: Cross Tab Query Detail Data
body: <p>I have a following table in mysql </p>
  
  <pre><code>  id int(11) 
   time_table_id int(11) ,
    week_day int(11) ,
    time_from datetime ,
    time_to datetime ,
    syllabus_detail_id int(11) ,
    room_id int(11) ,
    faculty_id int(11) ,
    is_recess bit(1) ,
   can_log bit(1) 
  </code></pre>
  
  <p><strong><a href="http://sqlfiddle.com/#!2/2b789/2" rel="nofollow noreferrer">i have written cross tab or pivot query as follows</a></strong></p>
  
  <p>The problem i am facing is in this image </p>
  
  <blockquote>
    <p><a href="https://i.stack.imgur.com/FoWfA.jpg" rel="nofollow noreferrer" title="Click here to ZOOM"><img src="https://i.stack.imgur.com/FoWfA.jpg" alt="enter image description here" title="Click here to ZOOM"></a></p>
  </blockquote>
  
  <p>The first two rows are been seperated but should be shown as merged row.</p>
  
  <p>Any help will be appreciated.</p>