Joining of tables (here inner join is needed) is possible to execute in two ways:
1. Through WHERE clause (a single opportunity before occurrence of standard SQL-92)
SELECT DISTINCT Product.maker, Laptop.speedFROM Product, Laptop WHERE Product.model = Laptop.model AND Laptop.hd >= 10
2. By means of explicit operation of JOIN
SELECT DISTINCT Product.maker,Laptop.speedFROM Product JOIN Laptop ON Product.model = Laptop.model WHERE Laptop.hd >= 10
Though Cистема управления реляционными базами данных (СУБД), разработанная корпорацией Microsoft. 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 produce the identical plans of executing both queries, the second variant which allows to separate conditions of joining the tables from conditions of filtering the rows is preferable.
To return to discussion of exercise #6
To solve a problem on SQL-EX.RU
go
Cистема управления реляционными базами данных (СУБД), разработанная корпорацией Microsoft.