Advertisement
Guest User

Untitled

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