Friday, 25 October 2013

Inner joins on multiple table, Easy way of mysql joins

Inner Joining three tables

 

select *
from
    tableA a
        inner join
    tableB b
        on a.common = b.common
        inner join 
    TableC c
        on b.common = c.common
 
 
 
 

You can join like this also 

 
 
 
SELECT * FROM TableA A,TableB B,TableC C
WHERE A.Column=B.Column 
  AND A.Column=B.Column 
  AND A.Column=C.Column 

No comments:

Post a Comment