Subject | Select from SP in a view |
---|---|
Author | Regina Phandu |
Post date | 2003-07-25T03:15:49Z |
Hi,
I need to select a value form store procedure in a view. I have the following
sql statement:
CREATE VIEW vPA
(
category,
description,
CatDetID,
pointdescr,
typepa,
)
AS
SELECT FIRST 100
a.category,
a.description,
b.CatDetID,
b.pointdescr,
sp_small_vPA.SupervisorF
FROM sp_small_vPA, evalcattab a INNER JOIN
evalcatdet b ON a.category = b.category
;
I have an error on sp_small_vPA.
The procedure itself is working. I can select the value from the store
procedure.
Can anybody help?
TIA,
Regina
I need to select a value form store procedure in a view. I have the following
sql statement:
CREATE VIEW vPA
(
category,
description,
CatDetID,
pointdescr,
typepa,
)
AS
SELECT FIRST 100
a.category,
a.description,
b.CatDetID,
b.pointdescr,
sp_small_vPA.SupervisorF
FROM sp_small_vPA, evalcattab a INNER JOIN
evalcatdet b ON a.category = b.category
;
I have an error on sp_small_vPA.
The procedure itself is working. I can select the value from the store
procedure.
Can anybody help?
TIA,
Regina