- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
SELECT A.ACCOUNT_ID, A.DESCRIPTION, A.TOTAL_BALANCE, A.DATA_CENTER, A.SALES_AMT, CASE WHEN A.ACCOUNT_ID = '10-200' AND A.DATA_CENTER = 'K00300' THEN (A.TOTAL_BALANCE - B.SALES_AMT) ELSE (A.TOTAL_BALANCE + A.SALES_AMT) END NEW_TOTAL FROM ACCOUNT_TEMP A LEFT OUTER JOIN ( SELECT A.ACCOUNT_ID, SUM(A.SALES_AMT) SALES_AMT FROM ACCOUNT_TEMP A GROUP BY A.ACCOUNT_ID ) B ON B.ACCOUNT_ID = A.ACCOUNT_ID
|syntax error in query expression in MS/ACCESS 2016 (DLOOKUP)||4||41|
|Access left join query||5||31|
|how to eliminate duplicates in a string variable in t-sql?||30||44|
|Left Join with Tuple returning more rows||10||60|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!