CREATE PROCEDURE SEL_140_210
(
selt VARCHAR(1),
stdt VARCHAR(10), --시작기간
endt VARCHAR(10) --종료기간
)
RETURNS
(
...
...
)AS
begin
for
select
..
..
from tr140t a
left outer join ..
....
if (:selt = '1') then ====>요기서 에러 나네요... if문을 어찌 쓰나요???
where T_adt >= :stdt and T_adt <= :endt else
where T_bdt >= :stdt and T_bdt <= :endt
|