Getting albums and album member details via FAMILY ID

[eluser]jedd[/eluser]
Oh, I see. I thought it was an intentional spacing. I rarely dump schemas, so didn't realise that information was appended by default. I suspect it would make restores a bit .. odd, though.

[eluser]CI_avatar[/eluser]

Code:

SELECT
  families.family_name,
  families.family_id,
  albums.id,
  albums.name,
  albums.description,
  albums.created_on,
  members.member_id,
  members.member_family_id,
  albums.family_id,
  members.member_forename,
  members.member_surname
FROM
  families
  INNER JOIN members ON (families.family_id = members.member_family_id)
  INNER JOIN albums ON (families.family_id = albums.family_id)

i supposed it will help.

Note: jed is correct. please identify the relationships of your table. (Add Foreign keys)