MySQL Query : select DISTINCT a.pinpai from kache_qiye as a inner join kache_zixie as b on b.pinpai = a.pinpai where a.catid = 83 and a.status = 99 and a.shangjia = 0 and status = 99 and zhuangtai = 1 and (rlzl like "%纯电动%" or rlzl like "%混合动力%" or rlzl like "%燃料电池%") and (b.rlzl like "%纯电动%" or b.rlzl like "%混合动力%" or b.rlzl like "%燃料电池%")
MySQL Error : Column 'status' in where clause is ambiguous
MySQL Errno : 1052
Message : Column 'status' in where clause is ambiguous
Need Help?