java.sql.SQLIntegrityConstraintViolationException: Column ‘del_flag‘ in where clause is ambiguous

  <select id="selectContractTransferList" parameterType="ContractTransfer" resultMap="ContractTransferResult">
        select crocosmiaContractTransfer.id, crocosmiaContractTransfer.tranfer_person_id,sysUser.nick_name as tranferPersonNickName ,crocosmiaContractTransfer.receive_person_id, crocosmiaContractTransfer.transfer_desc, crocosmiaContractTransfer.transfer_status, crocosmiaContractTransfer.transfer_date,
               crocosmiaContractTransfer.del_flag, crocosmiaContractTransfer.create_by, crocosmiaContractTransfer.create_time, crocosmiaContractTransfer.update_by, crocosmiaContractTransfer.update_time, crocosmiaContractTransfer.remark
        from crocosmia_contract_transfer crocosmiaContractTransfer
            left join sys_user sysUser on crocosmiaContractTransfer.tranfer_person_id=sysUser.user_id
<!--        <include refid="selectContractTransferVo"/>-->
        <where>  
            <if test="tranferPersonId != null  and tranferPersonId != ''"> and tranfer_person_id = #{tranferPersonId}</if>
            <if test="receivePersonId != null  and receivePersonId != ''"> and receive_person_id = #{receivePersonId}</if>
            <if test="transferDesc != null  and transferDesc != ''"> and transfer_desc = #{transferDesc}</if>
            <if test="transferStatus != null  and transferStatus != ''"> and transfer_status = #{transferStatus}</if>
            <if test="transferDate != null "> and transfer_date = #{transferDate}</if>
            and del_flag=0 ${dataScope} order by create_time desc
        </where>
    </select>

Caused by: java.sql.SQLIntegrityConstraintViolationException: Column ‘del_flag’ in where clause is ambiguous
注意在del_flag前面要加表的别名