This tutorial will show how to list all employees even when an employee is not tagged to any department.

Create below Department table in MySQL database

Insert data into Department table

Create below Employee table in MySQL database

Insert data into Employee table

Query

Output

Thanks for reading.

Software Professional, I am passionate to work on web/enterprise application. For more information please go to about me. You can follow on Twitter. You can be a friend on Facebook or Google Plus or Linkedin

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.