SELECT * FROM Pizzatyp, Kunde;
ergibt:
ID Pizzatyp.Name Preis ID1 Kunde.Name Vorname Telephon Adresse
1 Magerita 4,10 1 Maier Jean-Claude 01111/122323
1 Magerita 4,10 2 Abakus Jan-Richard 01111/1234643
1 Magerita 4,10 3 Zarvainsky Paul 01111/3334643
1 Magerita 4,10 4 Jallensteg Martin 01110/987654
1 Magerita 4,10 5 Wardenberg Martin 01110/100203
1 Magerita 4,10 6 Ast Stefan 01111/877621
1 Magerita 4,10 7 Lako Michael 01110/823444
2 Salami 5,20 1 Maier Jean-Claude 01111/122323
2 Salami 5,20 2 Abakus Jan-Richard 01111/1234643
2 Salami 5,20 3 Zarvainsky Paul 01111/3334643
2 Salami 5,20 4 Jallensteg Martin 01110/987654
2 Salami 5,20 5 Wardenberg Martin 01110/100203
2 Salami 5,20 6 Ast Stefan 01111/877621
2 Salami 5,20 7 Lako Michael 01110/823444
3 Prosciutto 5,20 1 Maier Jean-Claude 01111/122323
3 Prosciutto 5,20 2 Abakus Jan-Richard 01111/1234643
3 Prosciutto 5,20 3 Zarvainsky Paul 01111/3334643
3 Prosciutto 5,20 4 Jallensteg Martin 01110/987654
3 Prosciutto 5,20 5 Wardenberg Martin 01110/100203
3 Prosciutto 5,20 6 Ast Stefan 01111/877621
3 Prosciutto 5,20 7 Lako Michael 01110/823444
4 Regina 5,70 1 Maier Jean-Claude 01111/122323
4 Regina 5,70 2 Abakus Jan-Richard 01111/1234643
4 Regina 5,70 3 Zarvainsky Paul 01111/3334643
4 Regina 5,70 4 Jallensteg Martin 01110/987654
4 Regina 5,70 5 Wardenberg Martin 01110/100203
4 Regina 5,70 6 Ast Stefan 01111/877621
4 Regina 5,70 7 Lako Michael 01110/823444
5 Funghi 5,20 1 Maier Jean-Claude 01111/122323
5 Funghi 5,20 2 Abakus Jan-Richard 01111/1234643
5 Funghi 5,20 3 Zarvainsky Paul 01111/3334643
5 Funghi 5,20 4 Jallensteg Martin 01110/987654
5 Funghi 5,20 5 Wardenberg Martin 01110/100203
5 Funghi 5,20 6 Ast Stefan 01111/877621
5 Funghi 5,20 7 Lako Michael 01110/823444
6 vegetarisch 6,40 1 Maier Jean-Claude 01111/122323
6 vegetarisch 6,40 2 Abakus Jan-Richard 01111/1234643
6 vegetarisch 6,40 3 Zarvainsky Paul 01111/3334643
6 vegetarisch 6,40 4 Jallensteg Martin 01110/987654
6 vegetarisch 6,40 5 Wardenberg Martin 01110/100203
6 vegetarisch 6,40 6 Ast Stefan 01111/877621
6 vegetarisch 6,40 7 Lako Michael 01110/823444
7 Tonno 5,70 1 Maier Jean-Claude 01111/122323
7 Tonno 5,70 2 Abakus Jan-Richard 01111/1234643
7 Tonno 5,70 3 Zarvainsky Paul 01111/3334643
7 Tonno 5,70 4 Jallensteg Martin 01110/987654
7 Tonno 5,70 5 Wardenberg Martin 01110/100203
7 Tonno 5,70 6 Ast Stefan 01111/877621
7 Tonno 5,70 7 Lako Michael 01110/823444
8 Hawaii 5,70 1 Maier Jean-Claude 01111/122323
8 Hawaii 5,70 2 Abakus Jan-Richard 01111/1234643
8 Hawaii 5,70 3 Zarvainsky Paul 01111/3334643
8 Hawaii 5,70 4 Jallensteg Martin 01110/987654
8 Hawaii 5,70 5 Wardenberg Martin 01110/100203
8 Hawaii 5,70 6 Ast Stefan 01111/877621
8 Hawaii 5,70 7 Lako Michael 01110/823444
9 Sole Mio 6,20 1 Maier Jean-Claude 01111/122323
9 Sole Mio 6,20 2 Abakus Jan-Richard 01111/1234643
9 Sole Mio 6,20 3 Zarvainsky Paul 01111/3334643
9 Sole Mio 6,20 4 Jallensteg Martin 01110/987654
9 Sole Mio 6,20 5 Wardenberg Martin 01110/100203
9 Sole Mio 6,20 6 Ast Stefan 01111/877621
9 Sole Mio 6,20 7 Lako Michael 01110/823444
10 Tutti 6,40 1 Maier Jean-Claude 01111/122323
10 Tutti 6,40 2 Abakus Jan-Richard 01111/1234643
10 Tutti 6,40 3 Zarvainsky Paul 01111/3334643
10 Tutti 6,40 4 Jallensteg Martin 01110/987654
10 Tutti 6,40 5 Wardenberg Martin 01110/100203
10 Tutti 6,40 6 Ast Stefan 01111/877621
10 Tutti 6,40 7 Lako Michael 01110/823444
11 Frutti di Mare 6,20 1 Maier Jean-Claude 01111/122323
11 Frutti di Mare 6,20 2 Abakus Jan-Richard 01111/1234643
11 Frutti di Mare 6,20 3 Zarvainsky Paul 01111/3334643
11 Frutti di Mare 6,20 4 Jallensteg Martin 01110/987654
11 Frutti di Mare 6,20 5 Wardenberg Martin 01110/100203
11 Frutti di Mare 6,20 6 Ast Stefan 01111/877621
11 Frutti di Mare 6,20 7 Lako Michael 01110/823444
12 Calzone 5,70 1 Maier Jean-Claude 01111/122323
12 Calzone 5,70 2 Abakus Jan-Richard 01111/1234643
12 Calzone 5,70 3 Zarvainsky Paul 01111/3334643
12 Calzone 5,70 4 Jallensteg Martin 01110/987654
12 Calzone 5,70 5 Wardenberg Martin 01110/100203
12 Calzone 5,70 6 Ast Stefan 01111/877621
12 Calzone 5,70 7 Lako Michael 01110/823444
13 Diabolo 6,20 1 Maier Jean-Claude 01111/122323
13 Diabolo 6,20 2 Abakus Jan-Richard 01111/1234643
13 Diabolo 6,20 3 Zarvainsky Paul 01111/3334643
13 Diabolo 6,20 4 Jallensteg Martin 01110/987654
13 Diabolo 6,20 5 Wardenberg Martin 01110/100203
13 Diabolo 6,20 6 Ast Stefan 01111/877621
13 Diabolo 6,20 7 Lako Michael 01110/823444
14 Quattro Formaggi 6,70 1 Maier Jean-Claude 01111/122323
14 Quattro Formaggi 6,70 2 Abakus Jan-Richard 01111/1234643
14 Quattro Formaggi 6,70 3 Zarvainsky Paul 01111/3334643
14 Quattro Formaggi 6,70 4 Jallensteg Martin 01110/987654
14 Quattro Formaggi 6,70 5 Wardenberg Martin 01110/100203
14 Quattro Formaggi 6,70 6 Ast Stefan 01111/877621
14 Quattro Formaggi 6,70 7 Lako Michael 01110/823444
15 Quattro Stagioni 6,20 1 Maier Jean-Claude 01111/122323
15 Quattro Stagioni 6,20 2 Abakus Jan-Richard 01111/1234643
15 Quattro Stagioni 6,20 3 Zarvainsky Paul 01111/3334643
15 Quattro Stagioni 6,20 4 Jallensteg Martin 01110/987654
15 Quattro Stagioni 6,20 5 Wardenberg Martin 01110/100203
15 Quattro Stagioni 6,20 6 Ast Stefan 01111/877621
15 Quattro Stagioni 6,20 7 Lako Michael 01110/823444
16 Las Vegas 7,00 1 Maier Jean-Claude 01111/122323
16 Las Vegas 7,00 2 Abakus Jan-Richard 01111/1234643
16 Las Vegas 7,00 3 Zarvainsky Paul 01111/3334643
16 Las Vegas 7,00 4 Jallensteg Martin 01110/987654
16 Las Vegas 7,00 5 Wardenberg Martin 01110/100203
16 Las Vegas 7,00 6 Ast Stefan 01111/877621
16 Las Vegas 7,00 7 Lako Michael 01110/823444
17 Napoli 6,20 1 Maier Jean-Claude 01111/122323
17 Napoli 6,20 2 Abakus Jan-Richard 01111/1234643
17 Napoli 6,20 3 Zarvainsky Paul 01111/3334643
17 Napoli 6,20 4 Jallensteg Martin 01110/987654
17 Napoli 6,20 5 Wardenberg Martin 01110/100203
17 Napoli 6,20 6 Ast Stefan 01111/877621
17 Napoli 6,20 7 Lako Michael 01110/823444