一、问题描述
SQL查询时,报错:*Column 'STATELABEL' in where clause is ambiguous
二、解决
select a.* from reimbursement a left join t_flowstatert b on a.id = b.docid where istmp=0 and STATELABEL = "申请人"
漏了前缀,应该为 a.STATELABEL = "申请人"
SQL查询时,报错:*Column 'STATELABEL' in where clause is ambiguous
select a.* from reimbursement a left join t_flowstatert b on a.id = b.docid where istmp=0 and STATELABEL = "申请人"
漏了前缀,应该为 a.STATELABEL = "申请人"