rendered paste bodyQuery #1:
select
PLANID,
BENID,
BENTYPECD,
YTDREMAININGBALAMT,
PROJFSAFORFAMT
from
RPTCPEEBEN
where
PLANID = 06389
Return #1:
PLANID BENID BENTYPECD YTDREMAININGBALAMT PROJFSAFORFAMT
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 654 654
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H -83.58 0
06389 6 H -67.33 0
06389 6 H -425.34 0
06389 6 H -132.55 0
06389 6 H 0 0
06389 6 H -300 0
06389 6 H -12.29 0
06389 6 H -1634.11 0
06389 6 H 0 0
06389 6 H -91.91 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H -1200 0
06389 6 H 0 0
06389 6 H 0 0
06389 6 H -3000 0
06389 6 H -450 0
06389 6 H -3360 0
06389 1 D 0 0
06389 6 H -285.24 0
06389 6 H 0 0
43 Records Selected
Query #2:
select
PLANID,
BENID,
BENTYPECD,
YTDREMAININGBALAMT,
PROJFSAFORFAMT
from
RPTCPEEBEN
where
PLANID = 06389 and PROJFSAFORFAMT != 0
Returns nothing.