Guest User

Untitled

a guest
Sep 24th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. SELECT
  2.  
  3. ID_Table_One,
  4. Select_Info,
  5. Deb,
  6. Cre
  7.  
  8. FROM Table_Two
  9.  
  10. UNION
  11.  
  12. SELECT
  13.  
  14. ID_Table_One,
  15. "Total",
  16. IIF(SUM(Deb) - Sum(Cre) >= 0, SUM(Deb) - Sum(Cre), "" ),
  17. IIF(SUM(Deb) - Sum(Cre) <= 0, SUM(Deb) - Sum(Cre), "" )
  18.  
  19. FROM Table_Two
  20.  
  21. GROUP BY ID_Table_One;
  22.  
  23. SELECT
  24. [Table_Three].[Id_Table_Three],
  25. [Table_Three].[Id_Table_Three_Plus_Info]
  26. FROM Table_Three;
Add Comment
Please, Sign In to add comment