I have a problem with the following select querey.
select single a~stktype_ac b~stktype a~stktype_rec a~stktype_effrec a~recefffrom a~receffto a~effrecref into (actyp, potyp, reltyp, esto, from, to, agreeref) from z2rlv_rlacct_s35 as a left outer join z2rlacct_extit as b on a~acctno = b~acctno and b~acctpty = potype where a~acctno = acctno and a~achol = partner and a~acholty = partner_type.
where z2rlv_rlacct_s35 is a view which has 3 tables.
Can anybody suggest me better way to handle the query.
Any answers will bw appreciated.