In this article, I’ll discuss some of the more frequently used methods for consolidating data from multiple tables into a single result set: SELECT, JOIN, UNION and subqueries.

In the SQL code, I used fully qualified column names because I’m directly comparing the two tables, not merely using the result set as a passive resource. I’m not returning results from the ...

We're going to run this through the paces as I like the idea of free--especially at the cost of Red Gate SQL compare per developer. Even if we only use VS 2013 Express for SQL schema and data ...