Re: 'union' in cursor?

I can't see anything wrong with your statement but if you want to get rid of the union then you can try the following.

SELECT doc.doc_id
FROM document doc
WHERE doc.doc_type = 20
  AND (doc.documenttitle like '%TEST%' OR

       EXISTS (SELECT NULL
               FROM   segment seg
               WHERE  seg.doc_id = doc.doc_id
                 AND  seg.segmenttitle like '%TEST%')); 

Gordon Received on Tue Apr 29 1997 - 00:00:00 CEST