Guest User

Untitled

a guest
Aug 17th, 2019
75
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT (SELECT fname
  2. FROM GAL810.KATDOC
  3. WHERE fnrec = d.FCNODE)
  4. || ' - '
  5. || d.FNAME
  6. AS title,
  7. D.FTIDKGAL
  8. FROM gal810.katdoc d
  9. WHERE d.FCNODE != '8000000000000000'
  10. ORDER BY d.FCNODE
RAW Paste Data