|
研究了几天。还是觉得有点进步。
下面是我录像里面的代码
SELECT ord.OrderDate AS [Order Date],
ord.ShipCountry AS [Country],
CASE
WHEN ord.ShipRegion IS NULL
THEN '*N/A'
ELSE ord.ShipRegion
END AS [State-Province],
ord.ShipCity AS [City],
ord.ShipName AS [Company],
dtl.Quantity AS [Quantity],
(dtl.UnitPrice *
dtl.Quantity *
(1 - Discount)) AS [Total Order],
cat.CategoryName AS [Category],
pro.ProductName AS [Product],
CASE
WHEN pro.Discontinued = '0'
THEN 'Available'
ELSE 'Discontinued'
END AS [Status],
sup.CompanyName AS [Supplier],
emp.LastName AS [Employee]
FROM Orders ord
INNER JOIN "Order Details" dtl ON ord.OrderID = dtl.OrderID
INNER JOIN Products pro ON dtl.ProductID = pro.ProductID
INNER JOIN Categories cat ON pro.CategoryID = cat.CategoryID
INNER JOIN Suppliers sup ON pro.SupplierID = sup.SupplierID
INNER JOIN Employees emp ON ord.EmployeeID = emp.EmployeeID |
-
-
录像.part01.rar
200 KB, 下载次数: 319
-
-
录像.part02.rar
200 KB, 下载次数: 209
-
-
录像.part03.rar
200 KB, 下载次数: 193
-
-
录像.part04.rar
200 KB, 下载次数: 198
-
-
录像.part05.rar
200 KB, 下载次数: 196
-
-
录像.part06.rar
200 KB, 下载次数: 199
-
-
录像.part07.rar
200 KB, 下载次数: 198
-
-
录像.part08.rar
200 KB, 下载次数: 198
-
-
录像.part09.rar
20.72 KB, 下载次数: 166
-
-
代码.rar
523 Bytes, 下载次数: 152
|