On Wed, Sep 04, 2002 at 04:16:14PM +0200, Roger Perttu wrote:
> Ronald J Kimball wrote:
> 
> >If you have absolutely no control over the query, how do you know what
> >you're supposed to do with the results anyway?
> >
> >  
> >
> I store the result for later use in another query.
> 
> If this is the (pseudo) input to my program:
> 
>     select ID from table1
>         select Name from table2 where PersonID = ID
>         insert into table3 values(ID, Name)
> 
> Then ID from query one and Name from query two will be inserted into 
> table3. Queries might be spread across different databases and nest to 
> any depth (until I run out of  connections).

The design of your system is still not clear to me.  How do you know that
the results from queries 1 and 2 are to be used with query 3?  How do you
know that queries 1 and 2 each return a single value?  How do you know
which database you're supposed to use for each query?

Ronald

Reply via email to