1. the nameX is a parameter you receive and docid is a parameter you do
not receive.

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.

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