MYSQL Inner Join with possible empty tables

[Joe Deluca]

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, MemberMartialAr ts 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

[yarbrough40]

what you want are outer joins as opposed to "inner"

I knew a Joe Deluca back in high school in Ohio... No chance is there?

[Joe Deluca]

Thanks man that did the trick.

And no I'm from Canada ;)