Subject Re: [ib-support] subquery problem
Author German Terrazas
sorry, docid is an unknown value.


On Wed, 19 Mar 2003, Martijn Tonies wrote:

> 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."
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>