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)
SELECT DISTINCT Product.maker, Laptop.speedFROM Product, Laptop WHERE Product.model = Laptop.model AND Laptop.hd >= 10;
2. Explicit use of a JOIN statement
SELECT DISTINCT Product.maker,Laptop.speedFROM Product JOIN Laptop ON Product.model = Laptop.model WHERE Laptop.hd >= 10;
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
go
A database management system (DBMS) by Microsoft Corporation.