Thursday, May 15, 2008

How many types of JOIN are supported by MySQL? Which are they? Explain

There are three types of joins supported in mysql as inner, right and left.
The inner join displays all the rows from both tables where match is found.
left join returns all the rows from first table even if the match is not found in second table.
While the right join returns all the rows from second table even if match is not found in first table.

No comments:

Post a Comment