Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT p.NAZWISKO, p.ETAT, P.PLACA_POD, e.NAZWA AS NAZWA_KATEGORII_PLACOWEJ, z.NAZWA AS NAZWA_ZESPOLU
- FROM PRACOWNICY p, ZESPOLY z, ETATY e
- WHERE p.ID_ZESP = z.ID_ZESP AND (p.PLACA_POD >= e.PLACA_MIN AND p.PLACA_POD <= e.PLACA_MAX)
- AND p.ETAT != 'ASYSTENT'
- ORDER BY p.PLACA_POD DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement