rootuss

domowe

Apr 12th, 2017
129
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.  
  3. Studenci_dane.Nazwisko,
  4. Studenci_dane.Imie,
  5. Kierunki.Kierunek,
  6. Studenci_oceny.Matematyka
  7.  
  8.  
  9. FROM (Studenci_dane INNER JOIN Studenci_oceny ON Studenci_dane.ID_albumu = Studenci_oceny.ID_albumu)
  10.              INNER JOIN Kierunki ON Studenci_oceny.KOD_kierunku = Kierunki.KOD_kierunku
  11.  
  12.  
  13. WHERE Studenci_oceny.Matematyka BETWEEN 2 AND 4
  14.  
  15.  
  16. ORDER BY Kierunki.Kierunek;
RAW Paste Data