Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM `ПР`
- WHERE `ПР`.`Np` NOT IN
- (SELECT `ПР`.`Np`
- FROM `ПР`
- JOIN `СЛ` ON `СЛ`.`No` = `ПР`.`Noo`
- LEFT JOIN `Р_Н` ON `Р_Н`.`Код` = `СЛ`.`Код` and `Р_Н`.`Np` = `ПР`.`Np`
- WHERE `Р_Н`.`Код` IS NULL)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement