"Denis Carraro" <carden11_at_hotmail.com> wrote in message
news:8d506df0.0410150430.35cf8ac2_at_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)
I have a problem with my car. Can you help me?
Received on Fri Oct 15 2004 - 11:42:56 CDT
