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.
Thursday, May 15, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment