I have an application where I join tables using the query shown below. When I attempt to do a search on one of the joined table fields (for example, church_name), I get a PHP error 256 (in this case, Unknown column 'church_name' in 'field list') as soon as I begin typing in the Search box. The search feature works OK for fields from the member table (for example, member_last_name). This was not a problem with v3.1. Thanks for your help.
Jim Alexander
select m.member_id,
m.member_church_id,
m.member_last_name,
m.member_first_name,
m.member_middle_name,
m.member_name_suffix,
c.church_name,
c.church_city,
c.church_state,
c.church_district_id,
d.district_name,
m.member_address_1,
m.member_address_2,
m.member_city,
m.member_state,
m.member_postal_code,
m.member_country,
m.member_phone,
m.member_email_address,
ps.member_position_title
From `member` m
Right join `church` c on m.member_church_id=c.church_id
Right join `member_position` ps on ps.member_position_id=m.member_id
Right join `district` d on c.church_district_id=d.district_id
where (ps.member_position_display_flag='1') and (m.member_expiration_flag='0')
