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