It's showing me a list of people who have the relation mom attached to them. When I want to see the list of people who are "moms" of the list it is showing me.
I want to search the "people" information by all these criteria, but then return the "related" people of those people.
I've got private info on this database, so I can't share a link. But here is the SQL :
SQL: SELECT people.people_id, people.people_status, people.people_profilepic, people.people_first_n, people.people_last_n, people.people_gender, people.people_birthdate, people.people_grade, people.people_address, people.people_address_2, people.people_city, people.people_state, people.people_zip, people.people_phone_number, people.people_phone_number_alt_1, people.people_phone_number_alt_2, people.people_txt_provider_id, people.people_txt_on_off, people.people_email, people.people_email_alt_1, people.people_email_alt_2, people_tag.tag_id, tag.tag_title, people_step.people_step_id, people_step.step_id, people_place.place_id, place.place_title, people_relation.people_relation_id, people_relation.relation_id, people_relation.related_people_id FROM people LEFT JOIN people_tag ON (people.people_id = people_tag.people_id) LEFT JOIN tag ON (people_tag.tag_id = tag.tag_id) LEFT JOIN people_place ON (people.people_id = people_place.people_id) LEFT JOIN place ON (people_place.place_id = place.place_id) LEFT JOIN people_step ON (people.people_id = people_step.people_id) LEFT JOIN people_relation ON (people.people_id = people_relation.related_people_id) LEFT JOIN relation ON (people_relation.relation_id = relation.relation_id) WHERE (people_first_n LIKE '%Keegan%') AND (people_birthdate <= "2013-02-08 00:00:00") AND (people_birthdate >= "1912-02-08 00:00:00") AND ((people_relation.relation_id = '2')) GROUP BY people.people_id, people_tag.people_id, people_step.people_id, people_place.people_id
Hope that helps.
Thanks.
Keegan