Subject Re: [ib-support] subquery problem
Author Martijn Tonies
Hi German,

> No answers yet...I think this query should be easy to resolve at any
> professional data base engine.

It has nothing to do with the database engine ... I can easily cook
up some really weird constructs that you cannot easily solve :)

Isn't this what you're looking for?

I don't quite understand what you are saying, but one way to get what you
the rows you want in your example would be

SELECT name, page, docid, id
FROM tTable t1
WHERE exists(select 1 from tTable t2 where t1.docid = t2.docid and (

This will obtain all rows with the same docid, but with different name. Is
this what you are looking for?


If it isn't, were those two rows the only result you're expecting?

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."