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.

Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database table and index structures. Maintain table data integrity through constraints. Understand how to ...

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 ...