I now get an invalid column reference with the following:

(I am using FreeUDFLib)

Any help would be appreciated.


CREATE VIEW SUM_SALESBYDAYOFWEEK(
ORDERTYPE,
DAYOFWEEK,
DAYOFWEEKNAME,
TOTALSALES,
ORDERDATE)
AS
SELECT OrdersPermanent.OrderType, F_DayOfWeek(OrderDate) As DayOfWeek,
F_CDOWShort(OrderDate) As DayOfWeekName,
Sum(OrdersPermanent.OrderSub) AS TotalSales,
OrdersPermanent.OrderDate
FROM
OrdersPermanent GROUP BY OrderType, OrderDate;




Lee