Advertisement
gahcep

TestSQL3

Jun 5th, 2012
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.90 KB | None | 0 0
  1. SELECT _innerALL.employee_id, (_innerALL.Issuance-_innerALL.Payment) as CLIENT_DEPT
  2.   FROM
  3.   (
  4.     # Сумма всех платежей и задолженностей клиентов по работникам
  5.     SELECT p.employee_id, SUM(p.sum) as Issuance, _innerPAYMENT.Payment
  6.       FROM processing as p
  7.     INNER JOIN
  8.     (
  9.       # Сумма всех платежей клиентов по работникам
  10.       SELECT employee_id, SUM(sum) AS Payment
  11.         FROM processing
  12.       WHERE operation_id =
  13.         (
  14.           SELECT id FROM operation WHERE name = 'payment'
  15.         )
  16.       GROUP BY employee_id
  17.     )
  18.       AS _innerPAYMENT
  19.     ON _innerPAYMENT.employee_id = p.employee_id
  20.     WHERE p.operation_id =
  21.       (
  22.         SELECT id FROM operation WHERE name = 'issuance'
  23.       )
  24.     GROUP BY p.employee_id
  25.   )
  26.     AS _innerALL
  27. WHERE _innerALL.Issuance > _innerALL.Payment
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement