> Select payroll_tbl.location, ; &&more than 1 rec can exist due to promotions > payroll_tbl.division, ; > payroll_tbl.unit, ; > payroll_tbl.titleive, ; > payroll_tbl.tanf, ; > payroll_tbl.grant1, ; > payroll_tbl.hourgrant1, ; > payroll_tbl.grant2, ; > payroll_tbl.hourgrant2, ; > payroll_tbl.unempins, ; > payroll_tbl.wrkcompins, ; > payroll_tbl.retireperc, ; > payroll_tbl.empstatus, ; > payroll_tbl.realign_pct, ; > payroll_tbl.unemp_ins_pct, ; > payroll_tbl.wrk_comp_pct, ; > payroll_tbl.dob, ; > payroll_tbl.cntsnrdte, ; > payroll_tbl.ctitle, ; > payroll_tbl.health_ins, ; > payroll_tbl.retiree_med, ; > payroll_tbl.retire_type, ; > payroll_tbl.zstep, ; > payroll_tbl.prom_date, ; > payroll_tbl.pextra, ; &&a__gen4(1,25) > payroll_tbl.loc_long, ; > payroll_tbl.div_long, ; > payroll_tbl.unit_long, ; &&a__gen4(1,28) > payroll_tbl.JPCFJH, ; &&a__gen4(1,29) > payroll_tbl.JPCFTRMT ; &&a__gen4(1,30) > from payroll_tbl into array a__gen4 ; > where payroll_tbl.ssn == a1 and payroll_tbl.pp == c1 >>
> Select payroll_tbl.location, ; &&more than 1 rec can exist due to promotions > payroll_tbl.division, ; > payroll_tbl.unit, ; > payroll_tbl.titleive, ; > payroll_tbl.tanf, ; > payroll_tbl.grant1, ; > payroll_tbl.hourgrant1, ; > payroll_tbl.grant2, ; > payroll_tbl.hourgrant2, ; > payroll_tbl.unempins, ; > payroll_tbl.wrkcompins, ; > payroll_tbl.retireperc, ; > payroll_tbl.empstatus, ; > payroll_tbl.realign_pct, ; > payroll_tbl.unemp_ins_pct, ; > payroll_tbl.wrk_comp_pct, ; > payroll_tbl.dob, ; > payroll_tbl.cntsnrdte, ; > payroll_tbl.ctitle, ; > payroll_tbl.health_ins, ; > payroll_tbl.retiree_med, ; > payroll_tbl.retire_type, ; > payroll_tbl.zstep, ; > payroll_tbl.prom_date, ; > payroll_tbl.pextra, ; &&a__gen4(1,25) > payroll_tbl.loc_long, ; > payroll_tbl.div_long, ; > payroll_tbl.unit_long, ; &&a__gen4(1,28) > payroll_tbl.JPCFJH, ; &&a__gen4(1,29) > payroll_tbl.JPCFTRMT ; &&a__gen4(1,30) > payroll_tbl.warrant; &&<<<<<<<<<<<<-============= I added this line > from payroll_tbl into array a__gen4 ; > where payroll_tbl.ssn == a1 and payroll_tbl.pp == c1 >>