loop through a table and load another by ID

[#1]

Hi all,

could be that I have forgitten everything, but I am stuck with that Problem:

I Load a "Header" Table form the Database. In that table there is a ID wich is FK in an other table with details.

I cant load the whole detail table because thats too many records.

So I want to LOOP throgh the header Table and select all detail records for every ID.

In exaple:

Header:
LOAD ID;
Select ID from header_table;

for each ID in Header
Detail:
LOAD <All Fields>;
Select * from Detail_table where FK_ID = ID;
LOOP;

Thanks in advance

Alex