用语句块
begin
if ('qqw' not in ('11111111')) then
select distinct s.SeriesID,SeriesName from GYD_SeriesInfo s,GYD_SeriesInfoFactory f where s.SeriesID=f.SeriesID and FactoryID in ('GYFactory');
else
select distinct s.SeriesID,SeriesName from GYD_SeriesInfo s,GYD_SeriesInfoFactory f where s.SeriesID=f.SeriesID
end if;
end;是否希望在一条SQL中执行?
begin
if ('qqw' not in ('11111111')) then
select distinct s.SeriesID,SeriesName from GYD_SeriesInfo s,GYD_SeriesInfoFactory f where s.SeriesID=f.SeriesID and FactoryID in ('GYFactory');
else
select distinct s.SeriesID,SeriesName from GYD_SeriesInfo s,GYD_SeriesInfoFactory f where s.SeriesID=f.SeriesID
end if;
end;是否希望在一条SQL中执行?
写个存储过程吧!