'union' in cursor?
From: Hsin-tang Pai <htpai_at_gwis2.circ.gwu.edu>
Date: 1997/04/28
Message-ID: <5k2e52$m4l$1_at_cronkite.seas.gwu.edu>#1/1
Date: 1997/04/28
Message-ID: <5k2e52$m4l$1_at_cronkite.seas.gwu.edu>#1/1
[Quoted] Hi! Folks:
Does anyone ever try to declare a select union statement in a cursor? I did try it, but I fail.
the_test cursor is
select doc_id from document
where documenttitle like '%TEST%'
and doc_type = 20
union
select doc_id from document
where doc_type = 20
and doc_id in (select doc_id from segment
where segmenttitle like '%TEST%');
Can anyone tell me how to fix the problem? Thank you!
Borren
--
. .
. . . .
Received on Mon Apr 28 1997 - 00:00:00 CEST