MySQL Forums
Forum List  »  Newbie

help with join
Posted by: Andreas
Date: April 05, 2005 01:45PM

I have this problem with joins.
I have 3 tables

:tblDistricts:
id
district_name

:tblDistrictsOut:
ident_district
ident_member
available

:tblMembers:
id
first_name

Now i want to list all Districts from the :tblDistricts:
and get if its available from :tblDistrictsOut: the
link between :tblDistrictsOut: and :tblDistrict: is the
ident_district column, now i also want to know
what member that has the district. and that link is from ident_member
in :tblMembers: to id in :tblMembers:

So how am i gonna get this information in a sql script
Note: I want all Districts to show, even if it dosent have
a member asigned to it.

Options: ReplyQuote


Subject
Written By
Posted
help with join
April 05, 2005 01:45PM
April 05, 2005 02:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.