CREATE VIEW vw_Sales

AS
SELECT Sales.SaleNo AS [Sale Number], Sales.SaleDate AS [Sale Date], Customers.FirstName AS [First Name],
        Customers.LastName AS [Last Name], Categories.AgeBracket AS [Age Bracket],
        Products.ProductDescription AS [Item Description], Types.TypeDescription AS [Item Type],
        Products.Year AS [Year Made], Products.Price AS [Price ex. GST],
        dbo.fn_CalculateGST(Products.ProductID) AS [GST],                                                           -- Use CalcuateGST function to return
        (Products.Price + dbo.fn_CalculateGST(Products.ProductID)) AS [Total Price]                             -- GST for each ProductID

FROM Sales
    JOIN Customers ON Customers.CustomerID = Sales.CustomerID
    JOIN Categories ON Categories.CategoryID = Customers.CategoryID
    JOIN SaleProducts ON SaleProducts.SaleNo = Sales.SaleNo
    JOIN Products ON Products.ProductID = SaleProducts.ProductID
    JOIN Types ON Types.TypeID = Products.TypeID

GO