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.

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

Positive Resources

All of us have at least two or three things that excite us. We could talk about these subjects for hours. Good news!. Did you know that Site Built It! can turn this type of deep interest and enthusiasm into a revenue-generating business?

Review some of the Site Build It! case studies and you'll absolutely discover something that ignites more positive ideas into your mind.

SBI! Video Tour


Invest the most
important 30 minutes
you will spend online.

Click, sit back, and
understand why SBI!
makes you succeed.