select mbucfprename.prename_desc , mbmembmaster.memb_name , mbmembmaster.memb_surname , lnnplmavpayout.coop_id , lnnplmavpayout.mavpay_docno , lnnplmavpayout.sue_no , lnnplmavpayout.memcoop_id , mbmembmaster.member_no , lnnplmavpayout.mavpay_date , lnnplmavpayout.mavpay_amt, lnnplmavpayout.mavpay_status, lnnplmavpayout.bfmavbal_amt, lnnplmavpayout.entry_id, lnnplmavpayout.entry_date, lnnplmavpayout.entry_bycoopid from lnnplmavpayout , mbmembmaster , mbucfprename where ( lnnplmavpayout.memcoop_id = mbmembmaster.coop_id ) and ( lnnplmavpayout.member_no = mbmembmaster.member_no ) and ( mbucfprename.prename_code = mbmembmaster.prename_code )