wbach=> SELECT * FROM wypożyczenie NATURAL INNER JOIN klient;
idklienta | idwypozyczenia | datawypozyczenia | datazwrotu | oplata | idmiejsca | idplyty | nrdowodu | imię | nazwisko | dataurodzenia | email
| nrtelefonu
i |
-+----------- |
-+--------------- |
+ + |
+ |
+ |
+ |
-+---------- |
-+------------- |
-+------------- |
—+---------------- | |||
T 1 |
1 |
4 |
| 2013-07-12 |
| 2013-08-12 | |
30 | |
2 1 |
4 1 |
1234 |
| Jarosław |
| Knapinski |
| 1992-08-15 |
| jarek99@gmail. c | |
om |
1 2 |
513564879 1 |
3 |
| 2013-06-11 |
| 2013-06-30 | |
25 | |
5 | |
2 1 |
6234 |
| Marek |
| Stojanowski |
| 1991-07-06 |
| stojan5591@gmai |
1. com |
1 3 |
693564879 1 |
1 |
| 2013-05-01 |
| 2013-05-20 | |
20 | |
1 1 |
1 1 |
6359 |
| Piotr |
| Stojanowski |
| 1991-07-06 |
| stojan551991@gm |
ail.com |
1 4 |
793564879 1 |
2 |
| 2013-06-01 |
| 2013-06-10 | |
10 | |
3 | |
3 | |
4359 |
| Wojciech |
| 3ach |
| 1991-07-13 |
| baszek91@gmail. |
com |
1 5 |
593564879 1 |
5 |
| 2013-07-13 |
| 2013-08-09 | |
20 | |
4 1 |
5 | |
4859 |
| Adam |
| 3ach |
| 1985-02-28 |
| baszek85@gmail. |
com | 617564879
(5 rows)