My servers DB is using MySQL ver4.1.10.
I need to use a query in the type CREATE VIEW
The error I get back is complaining about my MySQL version. Can I not use VIEW in 4.1?
I need to use a query in the type CREATE VIEW
Code:
CREATE VIEW currentCostOfStock AS
SELECT P.partName, P.partNo, P.manufacturer, S.vehicleType, S.years, S.price, S.stockLevel, S.price * S.stockLevel AS productCost, SUM productCost AS stockCost
FROM Parts P, StockLedger S
WHERE P.partNo = S.partNo ;
