クエリーに失敗しました。(MySQL) Column: 'structure' in where clause is ambiguous SELECT id,const_area,body_cost,img_main,name,house_name,location,completion,t.structure AS structure,num_floor,use_for,land_shape,theme,DATE_FORMAT(date_start,'%Y年%c月') AS date_start,l_name_yomi,inputday
FROM tatetaie_dev AS t
LEFT JOIN a_admin.project AS ap ON prj_number = ap.project_number
LEFT JOIN a_admin.customer AS ac ON ap.customer_number = ac.customer_number
WHERE service_class = '1' AND valid = '1' AND structure = '4' ORDER BY id DESC