SQL Problem

From: Denis Carraro <carden11_at_hotmail.com>
Date: 15 Oct 2004 05:30:57 -0700
Message-ID: <8d506df0.0410150430.35cf8ac2@posting.google.com>

Hi

i have problem with this SELECT...

can u help me????

SELECT
  concat(concat(CAPUSERCUSTOM.SCHAR2,' '),CAPUSERCUSTOM.LCHAR1) AS Societa,
  concat(concat(CAPUSER.LASTNAME,' '),CAPUSER.FIRSTNAME) AS Dipendente,
  CAPUSER.LOGINNAME,
  CAPUSERENTITYXREF.CAPUSERAPNUMBER,
  concat(concat(to_char(STDACCTNGEXPORT.TRANSACTIONDATE,'DD.MM.YYYY'),
' - '),STDACCTNGEXPORT.CATEGORYTYPENAME),
  CASE WHEN STDACCTNGEXPORT.CATEGORYTYPENAME = 'Vitto e Alloggio Italia' THEN SUM(STDACCTNGEXPORT.SIGNEDAMOUNT) - 100 ELSE SUM(STDACCTNGEXPORT.SIGNEDAMOUNT) - 200 END FROM
  CAPUSER,
  CAPUSERENTITYXREF,
  CAPUSERCUSTOM,
  STDACCTNGEXPORT
WHERE
  ( CAPUSER.CAPUSERID=CAPUSERENTITYXREF.CAPUSERID )

  AND  ( CAPUSERENTITYXREF.CAPUSERID=CAPUSERCUSTOM.CAPUSERID  )
  AND  ( STDACCTNGEXPORT.CAPUSERID=CAPUSER.CAPUSERID  )
  AND  (

    ( CAPUSER.FIRSTNAME <> 'Test' )
    AND nvl(STDACCTNGEXPORT.CATEGORYTYPENAME,'Altre spese') IN ('Vitto e Alloggio Italia', 'Vitto e Alloggio Estero')

    AND ( to_char(STDACCTNGEXPORT.EXPORTDATE,'MM') = case when to_char(sysdate,'MM') = 1 then 12 else to_char(sysdate,'MM') - 1 end )

    AND ( to_char(STDACCTNGEXPORT.EXPORTDATE,'YYYY') = case when to_char(sysdate,'MM') = 1 then to_number(to_char(sysdate,'YYYY')) - 1 else to_number(to_char(sysdate,'YYYY')) end )   )
GROUP BY
  concat(concat(CAPUSERCUSTOM.SCHAR2,' '),CAPUSERCUSTOM.LCHAR1),   concat(concat(CAPUSER.LASTNAME,' '),CAPUSER.FIRSTNAME),   CAPUSER.LOGINNAME,
  CAPUSERENTITYXREF.CAPUSERAPNUMBER,
  concat(concat(to_char(STDACCTNGEXPORT.TRANSACTIONDATE,'DD.MM.YYYY'),
' - '),STDACCTNGEXPORT.CATEGORYTYPENAME)
Received on Fri Oct 15 2004 - 07:30:57 CDT