Sunday, 9 August 2015

How to Join more than two table in MySQL

Join two or more table in MySQL. Very easy steps to joining more than two table.
Here, table name = student,exam and grade.
Joining query on three table with common matching column. See below

SELECT *
from
    tableA
        inner join
    tableB
        ON  tableA.common =  tableB.common
        inner join
    TableC
        ON TableB.common = TableC.common

No comments:

Post a Comment