SELECT 
(SELECT CODE FROM LG_119_CLCARD CL WHERE 
CL.LOGICALREF= CLIENTREF) CODE ,
(SELECT DEFINITION_ FROM LG_119_CLCARD CL WHERE 
CL.LOGICALREF= CLIENTREF) DEFINITION_,
 ROUND(SUM(CASE WHEN SIGN=0 THEN AMOUNT ELSE 0-AMOUNT END),2) BALANCE,
 CLIENTREF LOGICALREF
 INTO BM_119_CH_BALANCE2
  FROM LG_119_01_CLFLINE
GROUP BY CLIENTREF
HAVING ROUND(SUM(CASE WHEN SIGN=0 THEN AMOUNT ELSE 0-AMOUNT END),2)<>0