MySQL LEFT JOIN allows you to get result set from two or more tables for certain matches.
Suppose you have two tables i.e. A and B. So if you join A to B using left join then all rows from the A tables will be displayed with matches a row from the B table.
SELECT user.name, course.name FROM `user` LEFT JOIN `course` on user.course = course.id;
Here all rows from user tables will be displayed and only matches rows will be displayed from order table.
Read Also: Compare two tables in MySQL
Lets see below example:
`user` table –
| id | name | course |
|---|---|---|
| 1 | A | 1 |
| 2 | B | 2 |
| 3 | C | 2 |
| 4 | D | 5 |
| 5 | E | (NULL) |
`course` table –
| id | name |
|---|---|
| 1 | HTML |
| 2 | CSS |
| 3 | JavaScript |
| 4 | PHP |
| 5 | Ajax |
So, the result will be:
| user.name | course.name |
|---|---|
| A | HTML |
| B | CSS |
| C | CSS |
| D | Ajax |
| E | (NULL) |
In a world where digital presence is paramount, the question isn't whether you should do…
Over the years, people have experimented with various methods to maintain healthy and beautiful hair.…
Your brand more than developing an attractive and creative logo and infectious motto. It's the…
Introduction Are you someone who has suffered from a personal injury and want to file…
Operating from home has emerged as one of the most popular ways of doing jobs…
If the consequences of our society’s ever-growing debt are what worries you, then it is…