select hremployee.coop_id, hremployee.emp_no, mbucfprename.prename_desc, hremployee.emp_name, hremployee.emp_surname, hremployee.salary_id from hremployee, mbucfprename where hremployee.prename_code = mbucfprename.prename_code select hremployee.coop_id, hremployee.emp_no, mbucfprename.prename_desc, hremployee.emp_name, hremployee.emp_surname, hremployee.sex, hremployee.salary_id, hrucfposition.pos_desc, hrucfemptype.emptype_desc, hrucfdeptgrp.deptgrp_desc from hremployee, mbucfprename, hrucfposition, hrucfemptype, hrucfdeptgrp, hrucfdeptline where hremployee.prename_code = mbucfprename.prename_code and hremployee.pos_code = hrucfposition.pos_code and hremployee.emptype_code = hrucfemptype.emptype_code and hremployee.deptgrp_code = hrucfdeptgrp.deptgrp_code and hrucfdeptgrp.deptline_code = hrucfdeptline.deptline_code select hus.salitem_desc, hprd.item_amt from hrpayroll hpr, hrpayrolldet hprd, hrucfsalaryitem hus where hpr.coop_id = hprd.coop_id and hpr.payrollslip_no = hprd.payrollslip_no and hprd.salitem_code = hus.salitem_code select hus.salitem_desc, hprd.item_amt from hrpayroll hpr, hrpayrolldet hprd, hrucfsalaryitem hus where hpr.coop_id = hprd.coop_id and hpr.payrollslip_no = hprd.payrollslip_no and hprd.salitem_code = hus.salitem_code