Exercise #6 (tips and solutions)
There are two ways to perform a table join (in this case, an inner join is needed):
1. Using a WHERE clause (the only option before the SQL-92 standard has been introduced)
2. Explicit use of a JOIN statement
Although the A database management system (DBMS) by Microsoft Corporation. SQL(Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management.SQL Server query optimizer will generate identical execution plans for both queries, the second alternative is preferable, since it allows to keep apart join conditions and row filtering criteria.
Return to discussion of exercise #6