Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW wycieczki_osoby_potwierdzone
- AS
- SELECT w.ID_WYCIECZKI, w.NAZWA, w.KRAJ, w.DATA, o.IMIE, o.NAZWISKO, r.STATUS
- FROM WYCIECZKI w
- JOIN REZERWACJE r ON w.ID_WYCIECZKI = r.ID_WYCIECZKI
- JOIN OSOBY o ON r.ID_OSOBY = o.ID_OSOBY
- WHERE r.STATUS = 'Z'
- OR r.STATUS = 'P';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement