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
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