I am trying to create a temporary view and get an error stating "illegal select function". Can anyone look at the code below and tell me what I am doing wrong?
create temporary view SPEEDYWORK (procnum, procdesc, tottime) as select procnum, procdesc, sum(timeout-timein) from workinfo where procnum = 'spdy-82' and procdesc contains '222' Jim
