Advertisement
Guest User

Untitled

a guest
Oct 15th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. SELECT *
  2. FROM `ПР`
  3. WHERE `ПР`.`Np` NOT IN
  4. (SELECT `ПР`.`Np`
  5. FROM `ПР`
  6. JOIN `СЛ` ON `СЛ`.`No` = `ПР`.`Noo`
  7. LEFT JOIN `Р_Н` ON `Р_Н`.`Код` = `СЛ`.`Код` and `Р_Н`.`Np` = `ПР`.`Np`
  8. WHERE `Р_Н`.`Код` IS NULL)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement