SQL View Örnek #2

Create View VW_Orders
As
Select
    E.FirstName,
    E.LastName,
    E.City,
    O.OrderDate,
    S.CompanyName,
    C.ContactName,
    OD.Quantity,
    P.ProductName,
    SP.CompanyName SupplierCompanyName,
    CT.CategoryName
From dbo.Employees E
Join dbo.Orders O On E.EmployeeID = O.EmployeeID
Join dbo.Shippers S On O.ShipVia = S.ShipperID
Join dbo.Customers C On O.CustomerID = C.CustomerID
Join dbo.[Order Details] OD On O.OrderID = OD.OrderID
Join dbo.Products P On OD.ProductID = P.ProductID
Join dbo.Suppliers SP On P.SupplierID = SP.SupplierID
Join dbo.Categories CT On P.CategoryID = CT.CategoryID
Go
Update VW_Orders Set FirstName = 'Michael 1' Where LastName='Suyama'