Re: How to use an nested table as a subquery?

Lutz Heermann <wkst1.ik6_at_mchp.siemens.de> writes:

> Hi everybody,
>
> So this is my proplem:
> I've got an table which I wan't to reverence by an column called id
> and I've got an nested table which holds some id's.
> How can use the nested table as a subquery, so that i can choose all rows from
> the table which have an id contained in the nested table:
>

select * from supertable p
where exists (select 1 from subtable b where p.id = b.id)

That's only one of many ways to do this, though.

Marc
--
This question has exactly one correct answer. Which one? A) A or B; B) B or C; C) C.

• Question 14, National Science Quiz, the Netherlands, 1998