mysql - SQL Query does not return intended values -

i working on database client of mine , on 1 of pages (written in php , html) need display of information on clients, when run following query (supposed select of rows in table 'families') returns total of 0 rows. when should return of rows in table

select families.id fam_id, families.last_name fam_surname, families.address_1 fam_address_1, families.address_2 fam_address_2, families.city_id fam_city, families.phone fam_phone, families.mobile fam_mobile, families.email fam_email, families.f_d_worker_1 fam_fdw_1, families.f_d_worker_2 fam_fdw_2, families.status_id fam_status_id, families.trans_date fam_trans_date, families.entry_date fam_entry_date, families.exit_date fam_exit_date, families.eligible_date fam_eligible_date, families.active_date fam_active_date, families.lga_loc_id fam_lga_id, families.facs_loc_id fam_facs_id, families.ind_status_id fam_indig_id, families.referral_id fam_ref_id, families.active_status fam_act_status, families.comm_org_id fam_com_org, city.id city_id, city.name city_name, city.state_id city_state, city.post_code post_code, states.id state_id, states.long_name state_name, states.abbrev state_abbrev, client_status.id client_stat_id, client_status.name client_stat_name, community_org.id com_org_id, community_org.name com_org_name, facs_location.id facs_id, facs_location.name facs_name, lga_location.id lga_id, lga_location.name lga_name, indig_status.id indig_id, indig_status.name indig_name, referrals.id ref_id, referrals.name ref_name, f_d_workers.id fdw_id, f_d_workers.first_name fdw_first_name, f_d_workers.last_name fdw_last_name, client_status.id client_id, client_status.name client_name `families`, `city`, `client_status`, `community_org`, `facs_location`, `f_d_workers`, `indig_status`, `lga_location`, `referrals`, `states` families.city_id = city.id , families.f_d_worker_1 = f_d_workers.id , families.f_d_worker_2 = f_d_workers.id , families.status_id = client_status.id , families.lga_loc_id = lga_location.id , families.facs_loc_id = facs_location.id , families.ind_status_id = indig_status.id , families.referral_id = referrals.id , families.comm_org_id = community_org.id 

without seeing schema or data, going guess 1 or more of joins in query not working way think going work. example, query implies every families record have non-null values city_id, f_d_worker_1, f_d_worker_2, status_id, lga_loc_id, facs_loc_id, ind_status_id, referral_id, , comm_org_id. if families record has values each of these fields, appear there no matching id field in 1 or more of corresponding table (city, f_d_workers, client_status, lga_locations, facs_locations, indig_status, referrals, community_org).

the first step typically use when complex query not work way think should working convert inner joins outer joins, , missing records.

if, on other hand, 1 or more of join elements optional (ie, there may not f_d_worker_2 id), should using outer joins in query itself. hope helps.

updated

select families.id fam_id, families.last_name fam_surname, families.address_1 fam_address_1, families.address_2 fam_address_2, families.city_id fam_city, families.phone fam_phone, families.mobile fam_mobile, families.email fam_email, families.f_d_worker_1 fam_fdw_1, families.f_d_worker_2 fam_fdw_2, families.status_id fam_status_id, families.trans_date fam_trans_date, families.entry_date fam_entry_date, families.exit_date fam_exit_date, families.eligible_date fam_eligible_date, families.active_date fam_active_date, families.lga_loc_id fam_lga_id, families.facs_loc_id fam_facs_id, families.ind_status_id fam_indig_id, families.referral_id fam_ref_id, families.active_status fam_act_status, families.comm_org_id fam_com_org, city.id city_id, city.name city_name, city.state_id city_state, city.post_code post_code, states.id state_id, states.long_name state_name, states.abbrev state_abbrev, client_status.id client_stat_id, client_status.name client_stat_name, community_org.id com_org_id, community_org.name com_org_name, facs_location.id facs_id, facs_location.name facs_name, lga_location.id lga_id, lga_location.name lga_name, indig_status.id indig_id, indig_status.name indig_name, referrals.id ref_id, referrals.name ref_name, workers1.id fdw1_id, workers1.first_name fdw1_first_name, workers1.last_name fdw1_last_name, workers2.id fdw2_id, workers2.first_name fdw2_first_name, workers2.last_name fdw2_last_name, client_status.id client_id, client_status.name client_name `families`  left outer join `city` on families.city_id = city.id left outer join `client_status` on families.status_id = client_status.id left outer join `community_org` on families.comm_org_id = community_org.id left outer join `facs_location` on families.facs_loc_id = facs_location.id left outer join `f_d_workers` workers1 on families.f_d_worker_1 = workers1.id left outer join `f_d_workers` workers2 on families.f_d_worker_2 = workers2.id left outer join `indig_status` on families.ind_status_id = indig_status.id left outer join `lga_location` on families.lga_loc_id = lga_location.id left outer join `referrals` on families.referral_id = referrals.id  left outer join `states` on city.state_id = states.id 

i think trying at.