Guest User

Untitled

a guest
Jul 5th, 2018
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
4CS 1.08 KB | None | 0 0
  1.     WITH rpts AS
  2.       (SELECT DISTINCT Rebarptabil_Abilitazione Abilitazione
  3.       FROM Rebarptabil
  4.       WHERE Rebarpt_Id IN
  5.         (SELECT Rebarpt_Id
  6.         FROM Rebarpt
  7.         WHERE Rebatrm_Id IN
  8.           (SELECT Rebatrm_Id
  9.           FROM Rebatrm
  10.           WHERE Rebatrm_Ndg IN
  11.             ( SELECT Rebacli_Ndg FROM Rebacli WHERE Rebacli_Ndg = '000000072855007'
  12.             )
  13.           )
  14.         )
  15.       ),
  16.       Trms AS
  17.       (SELECT DISTINCT Rebatrmabil_Abilitazione Abilitazione
  18.       FROM Rebatrmabil
  19.       WHERE Rebatrm_Id IN
  20.         (SELECT Rebatrm_Id
  21.         FROM Rebatrm
  22.         WHERE Rebatrm_Ndg IN
  23.           ( SELECT Rebacli_Ndg FROM Rebacli WHERE Rebacli_Ndg = '000000072855007'
  24.           )
  25.         )
  26.       )
  27.     SELECT DISTINCT *
  28.     FROM
  29.       (SELECT Rpts.*,
  30.         Rebacbi.Rebacbi_Tx_Des_Pro
  31.       FROM Rebacbi,
  32.         Rpts
  33.       WHERE Rebacbi.Rebacbi_Cd_Prodotto (+) = Rpts.Abilitazione
  34.       UNION ALL
  35.       SELECT Trms.*,
  36.         Rebacbi.Rebacbi_Tx_Des_Pro
  37.       FROM Rebacbi,
  38.         Trms
  39.       WHERE Rebacbi.Rebacbi_Cd_Prodotto (+) = Trms.Abilitazione
  40.       )
  41.     ORDER BY 1;
Add Comment
Please, Sign In to add comment