Skip to Content
0
Former Member
Jul 06, 2010 at 08:55 PM

Query help on totalling 2 account balances

14 Views

Hi Experts,

I have the following query:

SELECT SUM(T0.[SYSDeb] - T0.[SYSCred]) AS 'Production'

FROM JDT1 T0 INNER JOIN OJDT T1 ON T0.TransId = T1.TransId WHERE T0.[Account] = '_SYS00000000238' AND T0.[Account] = '_SYS00000000239'

If I add the second WHERE statement the query gives me no results. I want to see the total of the 2 account balances in this query.

Any help would be appreciated.

Marli