I Still want The Crew Compliment of NCC Discovery

I Now have all the fields I want, but I have too much information, Now I need to limit what is being returned

SELECT * FROM complement

JOIN Ships

ON complement.shipID = Ships.shipID

JOIN sfmembers

ON complement.personID = sfmembers.memberID;

While this is a Triple Table Join, nothing is stopping you from going further