Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1.
- SELECT T.ID_TOWARU, T.NAZWA_TOW, K.NAZWA_KAT
- FROM Kategoria AS K, Towar AS T
- WHERE T.ID_KATEGORIA = K.ID_KATEGORIA;
- 3.
- SELECT T.ID_TOWARU, T.NAZWA_TOW, K.NAZWA_KAT
- FROM Kategoria AS K, Towar AS T
- INNER JOIN Towar ON K.ID_KATEGORIA = T.ID_KATEGORIA
- WHERE T.OPIS IS NOT NULL;
- 5.
- SELECT K.IMIE, K.NAZWISKO, SUBSTRING(Z.DATA, 1, 4) AS ROK, SUBSTRING(Z.DATA, 6, 2) AS DZIEN, SUBSTRING(Z.DATA, 9, 2) AS MIESIAC
- FROM Klienci AS K, Zamowienia AS Z
- INNER JOIN Klienci ON Z.ID_KLIENTA = K.ID_klienta;
- 7.
- SELECT T.NAZWA_TOW, SUBSTRING(K.NAZWISKO,1, 5) AS NAZWISKO5LITER
- FROM (((Towar AS T, Klienci AS K
- INNER JOIN Zamowienia ON K.ID_KLIENTA = Zamowienia.ID_Klienta)
- INNER JOIN Zamowiony_towar ON Zamowienia.ID_ZAM = Zamowiony_towar.ID_Zam_Tow)
- INNER JOIN Towar ON T.ID_Towaru = Zamowiony_towar.ID_TOWAR);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement