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

> The problem I have is as follows:
>
>
> tTable=(name, page, docid, id) with an instance:
>
> ('name1', 1, 1, 1)
> ('name2', 2, 2, 2)
> ('name3', 1, 1, 3)
> ('name4', 2, 3, 4)
>
> It is needed all rows with name='name1' and name='name3' with same
> docid. From the table instance above, the result should be:
>
>
> ('name1', 1, 1, 1)
> ('name3', 1, 1, 3)

And docid is a known value? Or should things with docid = 2
also be listed?


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

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