ifitsx wrote:

>
> Ann, I don't know what I could be doing that I'm not telling you.
>

Ah. Are you running the statement in a stored procedure? If so,
you'll have to use the looping syntax. The statement as presented
works in isql.

<procedure xxx returns noteid1 integer, noteid2 integer,
folderid1 integer, folderid2 integer, subject1 varchar(120))
BEGIN
FOR select a.noteid, a.folderid, b.noteid, b.folderid, a.subject
from dbnotes a
join dbnotes b on (a.subject = b.subject)
where a.noteid < b.noteid
INTO :noteid1, :noteid2, :folderid1, :folderid2, :subject1

DO BEGIN
SUSPEND;
END;

Or something close to that...


Good luck,


Ann