How to use an nested table as a subquery?

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 any_table
 where id in (<subquery with nested table>)

Or is there any other way to solve this problem?

Lutz
--
Lutz Heermann
Isengaustr. 41
81739 München
+49-173-2318588
Lutz.Heermann_at_rz.tu-ilmenau.de Received on Thu Dec 10 1998 - 07:50:46 CST