We all are familiar with selecting the rows which has common data in multiple tables. And yes using joins are the most popular solution among the developers.

Now question is how to select rows which doesn’t exists in other tables.

lets say there are two tables employee and department.

Continue reading