Advertisement
meshdev

trigger me andreas

Feb 20th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.21 KB | None | 0 0
  1. (
  2.     SELECT g1.name
  3.     FROM ger61 g1
  4. )
  5. MINUS
  6. (
  7.     SELECT DISTINCT g.name
  8.     FROM ger61 g
  9.         join ger62 g2 ON (g2.id1 = g.id1)
  10.     WHERE EXISTS
  11.         (
  12.         SELECT DISTINCT g2.id1
  13.         ger62 g2
  14.         )
  15. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement