I want a List of the Crew Compliment of NCC Discovery

I need the sfmembers table joined to what I have

SELECT * FROM complement INNER JOIN sfmembers ON complement.personID = sfmembers.memberID;

But with the previous Join

SELECT * FROM complement

JOIN Ships

ON complement.shipID = Ships.shipID

JOIN sfmembers

ON complement.personID = sfmembers.memberID;