select query

Hi all,

i have following select statements. i had to get the out put as follows.

output:

pspid posid banfn ebeln lblni.

my select queries are:

select pspid werks from proj into table p_proj.

select posid werks from prps into table p_prps for all entries in p_proj where werks = p_proj-werks.

select banfn werks lblni from eban into table p_eban for all entries in p_prps where werks = p_prps-werks.

select lblni ebeln banfn from essr into table p_essr for all entries in p_eban where lblni = p_eban-lblni.

select ebeln from ekko into table p_ekko for all entries in p_essr where ebeln = p_essr-ebeln.

thing is i need to loop them to get output as mentioned above,can any body provide me code for this.

thanks in advance

siva