Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM
- (SELECT `ПР`.`Noo` AS Noo, COUNT(`ПР`.`Np`) AS C_Tot
- FROM
- `ПР`
- GROUP BY `ПР`.`Noo`) TotProj
- JOIN
- (SELECT
- `ОТ`.`No` AS Noo,
- COUNT(DISTINCT `ПР`.`Np`) AS C_Sat
- FROM
- `СЛ`
- JOIN
- `ОТ`
- ON
- `ОТ`.`КодР` = `СЛ`.`КодК`
- JOIN
- `ПР`
- ON
- `ОТ`.`No` = `ПР`.`Noo`
- JOIN
- `Р_Н`
- ON
- `СЛ`.`Код` = `Р_Н`.`Код` AND `Р_Н`.`Np` = `ПР`.`Np`
- GROUP BY
- `ОТ`.`No`) SatProj
- ON TotProj.Noo = SatProj.Noo
- WHERE TotProj.C_Tot = SatProj.C_Sat
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement