Advertisement
Guest User

Untitled

a guest
Jan 21st, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.40 KB | None | 0 0
  1. SELECT DISTINCT Studenci.Imie as "Imię", Studenci.Nazwisko, Studenci.Indeks, Stypendia.RodzajStypendium as "Rodzaj stypendium",
  2.         Stypendia.RokAkademicki
  3.     FROM Studenci, Stypendia, Wnioski
  4.     WHERE Wnioski.CzyPrzyznano IN
  5.         (SELECT Wnioski.CzyPrzyznano
  6.             FROM Wnioski
  7.             WHERE Wnioski.CzyPrzyznano = 'Przyznano' AND Wnioski.Indeks = Studenci.Indeks
  8.                 AND Wnioski.IDStypendium = Stypendia.IDStypendium)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement