Transact SQL 101 - Lesson 05_01_SQL.txt

(0 KB) Pobierz

USE AdventureWorksLT
GO

--INNER JOIN (Example 1)
SELECT s.salesorderid, s.orderdate, s.totaldue, s.customerid, c.companyname, c.emailaddress
FROM saleslt.salesorderheader s
  INNER JOIN saleslt.customer c ON s.customerid = c.customerid

--INNER JOIN (Example 2)
SELECT p.productid, p.productnumber, p.color, p.listprice, m.productmodelid, p.name AS ModelName
FROM saleslt.product p
  INNER JOIN saleslt.productmodel m ON p.productmodelid = m.productmodelid  

--INNER JOIN (Example 3)
SELECT c.name AS CategoryName, p.productid, p.name, p.listprice, p.productcategoryid
FROM saleslt.productcategory c
  INNER JOIN saleslt.product p ON c.productcategoryid = p.productcategoryid
WHERE p.color = 'silver' 
  AND p.listprice > 1000
ORDER BY CategoryName

Transact SQL 101 - Lesson 05_01_SQL.txt

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: