joeydeluca

Hi everyone, I am using the following query to retrieve member profile data: SELECT * FROM Members INNER JOIN MemberMartialArts on MemberMartialArts.mma_memberId = '$memberId' INNER JOIN MemberAbilities on MemberAbilities.ma_memberId = '$memberId' WHERE m_id = '$memberId' My problem is the tables, MemberMartialArts and MemberAbilities may possibly have no records where memberId = '$memberId'. I do not want to use three separate queries because as tested the speed was slower. Can anyone comment how I can modify this query to to make it work even of one of the table do not contain a memberId.. Thanks, Joe