Bed and Breakfast Form
Fill in the form and then click on "Process Form".
(Guest) Name:
City:
ArrivalDate:
Generated Default SQL Query:
select * from Guest, Reservation where Guest.GuestNr = Reservation.GuestNr
Back to Index
Form Query Results
GuestNr
Name
StreetNr
City
GuestNr
RoomNr
ArrivalDate
NrDays
101
Smith
12 Maple
Boston
101
1
10 May
2
101
Smith
12 Maple
Boston
101
2
20 May
1
101
Smith
12 Maple
Boston
101
3
15 May
2
102
Carter
10 Main
Hartford
102
3
10 May
5
103
Jones
6 Elm
Hartford
103
1
12 May
3
104
Smith
4 Oak
Providence
104
4
10 May
2
104
Smith
4 Oak
Providence
104
4
17 May
2
104
Smith
4 Oak
Providence
104
4
24 May
2
105
Green
10 Main
Boston
105
1
15 May
7
106
Johnson
15 Main
Boston
106
2
11 May
2