How to use join in mysql Reviewed by Momizat on . JOIN is used to get records from two or more tables. [caption id="attachment_625" align="alignnone" width="746"] Tables[/caption] Type of join JOIN Self JOIN LE JOIN is used to get records from two or more tables. [caption id="attachment_625" align="alignnone" width="746"] Tables[/caption] Type of join JOIN Self JOIN LE Rating: 0

How to use join in mysql

JOIN is used to get records from two or more tables.

tables

Tables

Type of join

  • JOIN
  • Self JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN

Join

It is used to get all rows when there is at least one match in both tables.

Join

Join

Join

Join

Self Join

It is used to join with itself (same table).

self join

self join

LEFT Join

It is used to get all rows from the left table, and the matched rows from the right table

Left join

Left join

left join

left join

RIGHT Join

It is used to get all rows from the right table, and the matched rows from the left table

Right join

Right join

Right join

Right join

FULL Join or Outer join

It is used to get rows when there is a match in one of the tables

Full join

Full join

full Join

full Join

Leave a Comment

© 2014 Powered By