MySQL Query : select DISTINCT a.pinpai from kache_qiye as a inner join kache_zaihuo as b on b.pinpai = a.pinpai where a.catid = 83 and a.status = 99 and a.shangjia = 0 and b.status = 99 and b.zhuangtai = 1 AND mlqj='130-180' AND rlzl='柴油' AND pinpai='3502' AND b.mlqj='130-180' AND b.rlzl='柴油' AND b.pinpai='3502'
MySQL Error : Column 'pinpai' in where clause is ambiguous
MySQL Errno : 1052
Message : Column 'pinpai' in where clause is ambiguous
Need Help?