Column ‘‘ in field list is a ambiguous

目录

sql如下

报错

原因

结果

sql如下

select DISTINCT cust_num from b_marketing_transfer_sync_14583 a left join b_marketing_sync_3710012 bon a.cust_num = b.cust_num where b.cust_num is NULL;

报错

原因

意思就是说 'cust_num'指代不明，就是说查询结果出现了多个cust_num，系统不知道你选的是哪一个了，需要指定一下

select DISTINCT a.cust_num

结果

select DISTINCT a.cust_num from b_marketing_transfer_sync_14583 a left join b_marketing_sync_3710012 bon a.cust_num = b.cust_num where b.cust_num is NULL;