Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW wycieczki_osoby_potwierdzone AS
- SELECT
- w.KRAJ,
- w.DATA,
- w.NAZWA,
- 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 = 'P';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement