--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

>
> 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.

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

Here is the source for my table:

CREATE TABLE DBNOTES (
NOTEID INTEGER NOT NULL
, FOLDERID INTEGER NOT NULL
, SUBJECT VARCHAR( 120 )
, AUTHOR VARCHAR( 120 )
, KEYWORDS VARCHAR( 80 )
, NOTES BLOB( 65535, 1 )
, CREATEDATESTMP DATE
, CREATETIMESTMP TIME
, EDITDATESTMP DATE
, EDITTIMESTMP TIME
, CONSTRAINT INTEG_2
PRIMARY KEY ( NOTEID )
)

I'm simply trying to see if there are any duplicates for the field
<subject>