To use the INNER JOIN syntax, you’d rewrite the query like this: SELECT Donors.DonorID,Donors.Donorname. ... When you execute a query using the LEFT JOIN syntax, SQL does two things: ...