title: Fetch record from two different table using php and mysql?
body: <p>I have two tables named </p>
  
  <p>1.Table A
  <br/>
  2.Table B</p>
  
  <p>I am giving the in table details below : </p>
  
  <p>Table A :</p>
  
  <pre>
  ======================
     id  |   Name  |
  ======================
     1   |   Blue  |
  ======================
     2   |   Green |
  ======================
     3   |   Red   |
  ======================
     4   |   Yellow|
  ======================
     5   |   Black |
  ======================
     6   |   Orange|
  </pre>
  
  <p>Table B :</p>
  
  <pre>
  ================================
    id |  table_id  |  value   |
  ================================
    1  |   1        |   x      |
  ================================
    2  |   2        |   z      |
  ================================
    3  |   3        |   W      |
  </pre>
  
  <p>Using this two tables,I want to display the values comes from two tables like below : </p>
  
  <pre>
   SL      |    Name   |
  ------------------------
   1       |    <b>Blue</b>   |
  ------------------------
   2       |    <b>Green</b>  |
  ------------------------
   3       |    <b>Red </b>   |
  ------------------------
   4       |    Yellow |
  ------------------------
   5       |    Black  |
  ------------------------
   6       |    Orange |
  </pre>
  
  <p>Above the view,Bold(Blue,Green,Yellow) means Table B consists the value Table A.</p>
  
  <p>Thanks in advance.</p>