Part 5:Joins

1.Select the guest number, guest first name, last name, and the arrival and departure dates for those guests that have bookings.

2.Paste the results.

3.Select the guest number, guest first name, last name, and arrival and departure dates whether or not there is a booking. (All guests in the guest table should appear)

Hint: Use Left or Right Join