Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO Lokalizacja (id,nazwa,adres) VALUES (3,"KATI","Katowice,Korfantego 105")
- SELECT id FROM Pogoda WHERE temperatura>20
- SELECT l.id, pr.dataProg FROM Lokalizacja AS l, prognoza AS pr, pogoda AS po WHERE pr.Lokalizacja_id=l.id AND pr.Pogoda_id=po.id AND po.Wilgotnosc>50
- SELECT l.Nazwa, po.id FROM Lokalizacja AS l, Pogoda AS po, Prognoza AS pr WHERE pr.Lokalizacja_id=l.id AND pr.Pogoda_id=po.id AND pr.dataProg="2015-07-02"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement