Help needed on query

[Hobby]

Hai,

I got a temp-table t-t1 and t-t2. both having similar signature.

now t-t1 has one record and t-t2 has another record.

i want to write a for each statement such that it will fetch record from t-t1 and then from t-t2.

Is this possible to do without copying data from both to one temp-table.?

 

[jdpjamesp]

I'm not entirely sure what you're trying to do, but yes you should be able to query both.

FOR FIRST t-t1 WHERE t-t1.<field> EQ <equality>,
FIRST t-t2 WHERE t-t2.<field> EQ <equality>:
END.

Is that what you're after? If not, you'll have to add more information as to what you want.