Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Pilka.ID, Pilka.Marka, Sport.ID AS Expr1, Sport.nazwa, PS.Stopien, Kolor.nazwa AS Expr2, Kolor.ID AS Expr3, PK.Stopien AS Expr4
- FROM Pilka INNER JOIN
- PS ON Pilka.ID = PS.ID_pilka INNER JOIN
- Sport ON PS.ID_sport = Sport.ID INNER JOIN
- Kolor ON Pilka.ID = Kolor.ID INNER JOIN
- PK ON Pilka.ID = PK.ID_pilka AND Kolor.ID = PK.ID_kolor
- WHERE (Sport.nazwa = 'tenis' AND PS.Stopien > 0) AND (Kolor.ID = 1 AND PK.Stopien > 0)
- ORDER BY PS.Stopien DESC
- SELECT Pilka.Marka, Sport.nazwa, PS.Stopien, Kolor.nazwa AS NazwaKoloru, PK.Stopien AS StopienKoloru
- FROM Pilka INNER JOIN
- PS ON Pilka.ID = PS.ID_pilka INNER JOIN
- Sport ON PS.ID_sport = Sport.ID INNER JOIN
- PK ON Pilka.ID = PK.ID_pilka INNER JOIN
- Kolor ON Kolor.ID = PK.ID_kolor
- WHERE Pilka.ID = 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement