Advertisement
Guest User

Untitled

a guest
Oct 15th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.52 KB | None | 0 0
  1. SELECT * FROM
  2. (SELECT `ПР`.`Noo` AS Noo, COUNT(`ПР`.`Np`) AS C_Tot
  3. FROM
  4. `ПР`
  5. GROUP BY `ПР`.`Noo`) TotProj
  6. JOIN
  7. (SELECT
  8.     `ОТ`.`No` AS Noo,
  9.     COUNT(DISTINCT `ПР`.`Np`) AS C_Sat
  10. FROM
  11.     `СЛ`
  12. JOIN
  13.     `ОТ`
  14. ON
  15.     `ОТ`.`КодР` = `СЛ`.`КодК`
  16. JOIN
  17.     `ПР`
  18. ON
  19.     `ОТ`.`No` = `ПР`.`Noo`
  20. JOIN
  21.     _Н`
  22. ON
  23.     `СЛ`.`Код` = _Н`.`Код` AND _Н`.`Np` = `ПР`.`Np`
  24. GROUP BY
  25.     `ОТ`.`No`) SatProj
  26. ON TotProj.Noo = SatProj.Noo
  27. WHERE TotProj.C_Tot = SatProj.C_Sat
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement