Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH rpts AS
- (SELECT DISTINCT Rebarptabil_Abilitazione Abilitazione
- FROM Rebarptabil
- WHERE Rebarpt_Id IN
- (SELECT Rebarpt_Id
- FROM Rebarpt
- WHERE Rebatrm_Id IN
- (SELECT Rebatrm_Id
- FROM Rebatrm
- WHERE Rebatrm_Ndg IN
- ( SELECT Rebacli_Ndg FROM Rebacli WHERE Rebacli_Ndg = '000000072855007'
- )
- )
- )
- ),
- Trms AS
- (SELECT DISTINCT Rebatrmabil_Abilitazione Abilitazione
- FROM Rebatrmabil
- WHERE Rebatrm_Id IN
- (SELECT Rebatrm_Id
- FROM Rebatrm
- WHERE Rebatrm_Ndg IN
- ( SELECT Rebacli_Ndg FROM Rebacli WHERE Rebacli_Ndg = '000000072855007'
- )
- )
- )
- SELECT DISTINCT *
- FROM
- (SELECT Rpts.*,
- Rebacbi.Rebacbi_Tx_Des_Pro
- FROM Rebacbi,
- Rpts
- WHERE Rebacbi.Rebacbi_Cd_Prodotto (+) = Rpts.Abilitazione
- UNION ALL
- SELECT Trms.*,
- Rebacbi.Rebacbi_Tx_Des_Pro
- FROM Rebacbi,
- Trms
- WHERE Rebacbi.Rebacbi_Cd_Prodotto (+) = Trms.Abilitazione
- )
- ORDER BY 1;
Add Comment
Please, Sign In to add comment