Cross Database Selection

[Roop]

I am looking to a solution whereby the results of a search on one database can be used in a selection for another one.

Very simply I want to query a database using a certain set of parameters and for this to return a list of items that could subsequently used in a query for another database.

e.g.

From Database 1

Select itemnum where maturedate = today

From Database 2

Select itemnum, otherDate, Descriptor - using Database 1 query list

Thank you

[#2]

Maybe

Select1:

LOAD relavant feilds;

sqlselect db;

varWHERE1 = peek ('feild',0,'Select1');

select2:

Load relevant feilds;

sqlselect db where feild = varWHERE1;

or do the loads before, then res load with loop, use iterator insted of index 0 to make it dynamic

[#3]

not sure if that helps but its a guess