Guest User

Untitled

a guest
Jul 17th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. SELECT
  2. o.imie, o.nazwisko, o.pesel
  3. FROM tb_osoba o , tb_kartyNAU k where o.nauczyciel = 1 AND
  4. (o.nrKartyNau = '' OR o.nrKartyNau is NULL OR k.terminKartyNau = '' OR k.terminKartyNau is NULL OR k.terminKartyNAU < 1263821816)
  5. AND o.pesel != '' AND
  6. (o.telDomowy != '' OR o.komorkaPrywatna != '' OR o.komorkaSluzbowa != '')
  7. and o.id in(28059,28060,28061,28096,28099) and o.nrKartyNau = k.numer
Add Comment
Please, Sign In to add comment