Our Join Criteria for this is...
FROM complement INNER JOIN Ships ON complement.shipID = Ships.shipID;