Yes.

You must search that/those docid which has/have all nameX as x-times you
receive it.

thanks,
german

On Wed, 19 Mar 2003, Martijn Tonies wrote:

>
>
> > 1. the nameX is a parameter you receive and docid is a parameter you do
> > not receive.
>
> Eh... What? So you want only rows with a name = nameX?
> Or, eh - que?
>
> > 2. you cannot know how many nameX parameters receive. That is, for the
> > example I sent there are two, but in other examples they could be 7 or 8.
>
> What does this mean? What result are you expecting?
>
>
> 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."
>
> >
> >
> >
> >
> > On Wed, 19 Mar 2003, Svein Erling Tysvaer wrote:
> >
> > > 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
> (t1.name
> > > <> t2.name))
> > >
> > > This will obtain all rows with the same docid, but with different name.
> Is
> > > this what you are looking for?
> > >
> > > Set
> > >
> > > At 10:08 19.03.2003 -0300, you 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)
> > > >
> > > >I hope you help me.
> > > >
> > > >thanks,
> > > >german
> > >
> > >
> > >
> > > 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/
> > >
> > >
> > >
> >
> >
> >
> > 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/
> >
> >
> >
>
>
>
> 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/
>
>
>