Any idea why this does not work? They gave me this and I'm not quite strong with SQL...

select

 

         l.[ACCOUNT_ID],

         t.[ACCOUNTING_PERIOD_ID],

         l.[AMOUNT],

         l.[CLASS_ID],

         l.[COST_CENTERS_ID],

         t.[CURRENCY_ID],

         l.[DATE_LAST_MODIFIED],

         l.[DEPARTMENT_ID],

         t.[IS_NON_POSTING],

         cast (null as timestamp) as [LAST_MODIFIED_DATE] ,

         l.[LOCATION_ID],

         l.[MEMO],

         t.[TRANDATE],

         [TRANDATE_PERIOD] = to_number (to_char (t.[TRANDATE], 'YYYYMM')),

         t.[TRANID],

         l.[TRANSACTION_ID],

         l.[TRANSACTION_LINE_ID],

         t.[TRANSACTION_NUMBER],

         t.[TRANSACTION_SOURCE],

         t.[TRANSACTION_TYPE],

         l.[SUBSIDIARY_ID]

              

               from transactionline l

               inner join TRANSACTION t on

                 t.TRANSACTION_ID  = l.TRANSACTION_ID +0

 

        where
         l.[DATE_LAST_MODIFIED] > to_date ('17/09/2021 06:29:30 AM', 'dd/mm/yyyy HH:MI:SS PM')

The brackets will be from a SQL server linked server query - remove them

thanks @CD

a lot of the column names look wrong

yup

I agree with you