now i think it will work: (:-)

select * from Table T1
inner join Table T2 on t2.docid = T1.docid
where (t1.name = 'name1' or t1.name = 'name3') and (t2.name = 'name1' or
t2.name = 'name3'

Regards
Bogdan

-----Original Message-----
From: German Terrazas [mailto:german@...]
Sent: Wednesday, March 19, 2003 2:09 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] subquery problem


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

On Wed, 19 Mar 2003, Martijn Tonies wrote:

> Hi,
>
> > hi !!
> >
> > I want to perform a subquery like the simple following one:
> >
> >
> > select K.*
> > from (select *
> > from tablename
> > where field1=val1) K
> >
> > It always raise an error at the select statement next to from.
> > How can I do that ?
>
> You can't.
>
> Now, if you tell us what you're trying to accomplish, perhaps
> we can help?
>
>
> 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/
>
>
>



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/