title: How Remove duplicate column value after JOIN in MYSQL?
body: <p>I want to get data from multiple tables using join. 
  Its giving unique rows, but the column values are repeated and 
  I'm not able to remove the duplicate values, so how to do it?</p>
  
  <p>These are my tables </p>
  
  <p>TABLE A  </p>
  
  <pre><code>A_ID    A_NAME      
  -----   -------
  1       ONE         
  2       TWO         
  3       THREE       
  </code></pre>
  
  <p>TABLE B</p>
  
  <pre><code>A_ID    B_ID    CAT         
  -----   -----   --------
  1       1       CRICKET     
  1       2       FOOTBALL    
  2       3       HOCKEY      
  3       4       TENISH      
  3       7       BASE BALL   
  </code></pre>
  
  <p>TABLE C </p>
  
  <pre><code>B_ID    NAME
  ------  ------
  1       ASN
  1       MARK
  1       JOHN
  2       JACKY
  3       RAJ
  3       SAM
  </code></pre>
  
  <p>EXPECTED OUTPUT             </p>
  
  <pre><code>A_ID    A_NAME  B_ID    CAT         NAME
  -----   ------  -----   -------     ------
  1       ONE     1       CRICKET     ASN
                                      MARK
                                      JOHN
                  2       FOOTBALL    JACKY
  2       TWO     3       HOCKEY      RAJ
                                      SAM
  3       THREE   4       TENISH
                  7       BASEBALL
  </code></pre>
  
  <p>Query :-</p>
  
  <pre><code>SELECT   A.A_ID
          ,A.A_NAME
          ,B.B_ID 
          ,B.CAT          
          ,C.NAME
  FROM     A,B,C 
  WHERE    A.A_ID = B.B_ID 
  AND      B.B_ID = C.C_ID 
  GROUP BY A.A_ID,B_B_ID;
  </code></pre>