ifitsx wrote:

>>
>> 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
>
> The above returns the following error:
>
> ISC ERROR CODE:335544652
>
> ISC ERROR MESSAGE:
> multiple rows in singleton select
>

You're doing something you're not telling us about. That
statement is not designed to return a single row and won't
produce the error you report unless you're using it as
a subquery in another statement.


Good luck,


Ann