i have mysql database includes 2 tables called individuals , households. fields individuals table include: -ind_id -first_name -middle_name -last_name -household_id the fields households table include: -household_id -head_first_name -head_middle_name -head_last_name -address -city -province_state -country -postal_code -phone there foriegn key relationship between household_id fields in 2 tables. intent of 2 tables group individuals various households , able produce report listing selecting individuals database , group them household. isn't problem. using sql , php, have no problem producing list looks this: -household head address phone occupants -jones, robert john 1234 deadend st., anytown, usa 98004 (555) 420-5186 jones, ann leslie -jones, robert john 1234 deadend st., anytown, usa 98004 (555) 420-5186 jones, percy james -jones, robert john 1234 deadend st., anytown, usa 98004 (555) 420-5186 ...