Exercise #6 (tips and solutions)

	Common mistakes in solving SELECT statement exercises Tips and solutions 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) Console Execute SELECT DISTINCT Product.maker, Laptop.speed FROM Product, Laptop WHERE Product.model = Laptop.model AND Laptop.hd >= 10; SELECT DISTINCT Product.maker, Laptop.speed FROM Product, Laptop WHERE Product.model = Laptop.model AND Laptop.hd >= 10; Scheme 2. Explicit use of a JOIN statement Console Execute SELECT DISTINCT Product.maker,Laptop.speed FROM Product JOIN Laptop ON Product.model = Laptop.model WHERE Laptop.hd >= 10; SELECT DISTINCT Product.maker,Laptop.speed FROM Product JOIN Laptop ON Product.model = Laptop.model WHERE Laptop.hd >= 10; Scheme 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 Solve this task at SQL-EX.RU exercise 6 inner join tips and solutions

SQL Problems and solutions