Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT str_antragnummer FROM zl_mitarbeiter_za JOIN xdg_vbluser_ext ON zl_mitarbeiter_za.ref_userid = xdg_vbluser_ext.lid
- WHERE (zl_mitarbeiter_za.ref_statusid = 1 OR zl_mitarbeiter_za.ref_statusid = 2)
- AND xdg_vbluser_ext.b_deleted != TRUE
- AND xdg_vbluser_ext.b_disabled != TRUE
- AND (SELECT dt_dienstjahrbeginn FROM zl_mitarbeiter
- JOIN zl_mitarbeiter_za ON zl_mitarbeiter_za.ref_userid = zl_mitarbeiter.lid WHERE str_antragnummer = str_antragnummer)
- > (SELECT dt_beginn FROM zl_mitarbeiter_za WHERE str_antragnummer = str_antragnummer)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement