Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. SELECT str_antragnummer FROM zl_mitarbeiter_za JOIN xdg_vbluser_ext ON zl_mitarbeiter_za.ref_userid = xdg_vbluser_ext.lid
  2. WHERE (zl_mitarbeiter_za.ref_statusid = 1 OR zl_mitarbeiter_za.ref_statusid = 2)
  3. AND xdg_vbluser_ext.b_deleted != TRUE
  4. AND xdg_vbluser_ext.b_disabled != TRUE
  5. AND (SELECT dt_dienstjahrbeginn FROM zl_mitarbeiter
  6. JOIN zl_mitarbeiter_za ON zl_mitarbeiter_za.ref_userid = zl_mitarbeiter.lid WHERE str_antragnummer = str_antragnummer)
  7. > (SELECT dt_beginn FROM zl_mitarbeiter_za WHERE str_antragnummer = str_antragnummer)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement