I have a sql statement that I cannot get to work the way I want.
The statement as it currently exists is.
SELECT eeun, eedpt, plbemp, eenam, plbbg1, plbhrs , plbptp FROM
PRLBH, EEMP WHERE PLBEMP = EEENO and PLBPTP in('CO','OH',
EETDT = 0 and EEDPT = '081' and PLBWDT = 20090115
GROUP BY PLBEMP,EENAM,PLBBG1, PLBHRS , PLBPTP,EEUN, EEDPT Order by
I am trying to get 1 record per employee, but I cannot find the
What am I missing here?