SELECT u.id, CONCAT(u.fname,' ',u.lname) AS name, uo.occupation, uo.employer, CONCAT(c.addr1,' ',c.addr2,' ',c.addr3) AS address, c.city, c.state, c.zip, r.relationship FROM users AS u LEFT JOIN users_contactinfo AS c ON c.userid = u.id LEFT JOIN users_other AS uo ON uo.userid = u.id LEFT JOIN users_relationship AS ur ON ur.userid = u.id LEFT JOIN relationships AS r ON r.id = ur.relationshipid WHERE u.lname LIKE 'Roach%' AND u.fname LIKE 'Kathy%' ORDER BY u.lname
array(13) {
["lastname"]=>
string(5) "Roach"
["firstname"]=>
string(5) "Kathy"
["address"]=>
string(7) "Address"
["city"]=>
string(4) "City"
["state"]=>
string(5) "State"
["zip"]=>
string(8) "Zip code"
["identity"]=>
string(2) "ID"
["employer"]=>
string(8) "Employer"
["module"]=>
string(2) "48"
["step"]=>
string(1) "1"
["child"]=>
string(2) "49"
["action"]=>
string(18) "search_constituent"
["submit2"]=>
string(7) "Find >>"
}
