need help joining tables in sql
<p>i cant get around this question in my assesment,need a little help,</p>

<p>q)What are the BookingIDs and check in and out dates for bookings for Michelle Bonnier?
using the global holidays database.</p>

<p>A)</p>

<pre><code>select bookingid,guestid,firstname,lastname,checkindate,checkoutdate
from guests
join bookings on guests.GuestID = bookings.GuestID
where firstname = "Michelle"
and lastname = "Bonnier";
</code></pre>

<p>Error Code: 1066. Not unique table/alias: 'guests'</p>