title: How to select one unique value in mysql for the first row then show nothing for that value, BUT show all the records?
body: <p>there are 2 mysql table like this</p>
  
  <h2>table 1</h2>
  
  <blockquote>
    <p>--id-----config_name<br>
    --1-----OS<br>
    --2-----Control Panel<br>
    --3-----Bandwidth</p>
  </blockquote>
  
  <h2>table 2</h2>
  
  <blockquote>
    <p>id --    config_id---    config_Option_name ---   Price<br>
    1--------1-------------Windows 2008--------20.00<br>
    2--------1-------------CentOs 5----------------0.00<br>
    3--------2-------------whm/cPanel-----------30.00<br>
    4--------2-------------Plesk-------------------50.00<br></p>
  </blockquote>
  
  <hr>
  
  <p>Now I want to show them like this, ONLY USING MYSQL.</p>
  
  <blockquote>
    <ol>
    <li>OS<br><br>
    Windows 2008 = 20.00<br><br>
    CentOs 5 = 00.00<br><br></li>
    <li>Control Panel<br><br>
    whm/cPanel= 30.00<br><br>
    Plesk = 50.00<br><br></li>
    </ol>
  </blockquote>
  
  <p>IS THIS  POSSIBLE? So now "os" or "control panel" are selected once although if we use group by or join it comes twice. </p>
  
  <p>Using single SQL statement</p>