Sql Exclusion

The coolest way to utilize sql subquery and sql join is to obtain exclusion or inclusion list,hence let's call it sql exclusion.

You have a table (master table) with rowID as its primary key. You are given another table (extra table) that listed some rowID

You are to perform two tasks:

• One: List rows in master table that are not in the extra table.
• Two: List rows in master table that are in the extra table.

How are you going to do that?

You can either use Sql Subquery or Sql Join. Both will give the same result. There are cases where Sql Join performs better than Sql Subquery, that is usually when dealing with big data. There are also cases where Sql Subquery is the only solution.

Buy at AllPosters.com
A bend in the road is not the end of the road... unless you fail to make the turn