Sounds like you want to join the 2 tables.
SELECT...
FROM b,a
WHERE
b.e=a.id
--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
> I am trying to do the following:
>
> 1. open cursor cur1 to retreive all a.id rows in table a
> 2. for each a.id retreived from table a do the following:
> a) open cursor cur2 and retreive only those rows
> from table b where a.id = b.e
> b) write some text to a file
Received on Fri Jul 24 1998 - 21:24:33 CDT
