Hi,
I want to create a view in MSSQL like this ;
create view Invoices AS
SELECT Orders.ShipName, Orders.ShipAddress, Customers.CompanyName AS CustomerName,(FirstName + ' ' + LastName) AS Salesperson,
Shippers.CompanyName As ShipperName,
"Order Details".ProductID, Products.ProductName, "Order Details".UnitPrice, "Order Details".Quantity,
"Order Details".Discount,
(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS ExtendedPrice, Orders.Freight
FROM Shippers INNER JOIN
(Products INNER JOIN
(
(Employees INNER JOIN
(Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID)
ON Employees.EmployeeID = Orders.EmployeeID)
INNER JOIN "Order Details" ON Orders.OrderID = "Order Details".OrderID)
ON Products.ProductID = "Order Details".ProductID)
ON Shippers.ShipperID = Orders.ShipVia
I used dbpExecSQL action but I coudn't be succesfully. Can you Help me ?
Mehmet BAKITKAL