Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT p.NAZWISKO, p.ETAT, COALESCE(p.PLACA_POD * 12 + p.PLACA_DOD, p.PLACA_POD * 12) AS ROCZNA_PLACA,
- z.NAZWA AS NAZWA_ZESPOLU, e.NAZWA AS NAZWA_ETATU
- FROM PRACOWNICY p, ZESPOLY z, ETATY e
- WHERE p.ID_ZESP = z.ID_ZESP AND p.ETAT = e.NAZWA
- AND COALESCE(p.PLACA_POD * 12 + p.PLACA_DOD, p.PLACA_POD * 12) > 5500
- AND (p.ETAT = 'ADIUNKT' OR p.ETAT = 'ASYSTENT')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement