INTERSECT in SQL Server
In today’s blog posting I want to talk about the INTERSECT set operation in SQL Server. The INTERSECT set operation intersects two sets with each other and returns the rows that appear with identical column values in both sets. The following picture illustrates this concept. INTERSECT vs. Inner Join As you will realize, it is …
