• hy , thanks members

    my problems is resolved ...

    there is my query :

    SELECTmvtDtate

    ,mvtMDebCred

    ,CASE WHEN TypemvtMDebCred = 'D' THEN mvtMDebCred END AS mvtMDeb

    ,CASE WHEN TypemvtMDebCred = 'C' THEN mvtMDebCred END AS mvtMCred

    ,TypemvtMDebCred

    FROM...