mysql 表别名与已有表名重复_联表查询时，相同字段未取别名导致报错（mysql）...

Integrity constraint violation – yii\db\IntegrityException

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'company_id' in where clause is ambiguous

The SQL being executed was: SELECT COUNT(*) FROM `crm_customer` LEFT JOIN `crm_customer_combine` `cc` ON `crm_customer`.`id` = `cc`.`customer_id` WHERE (`company_id`=11) AND ((`cc`.`level`=1) AND (`cc`.`administrator_id`=1))

Error Info: Array

(

[0] => 23000

[1] => 1052

[2] => Column 'company_id' in where clause is ambiguous

)

↵

Caused by: PDOException

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'company_id' in where clause is ambiguous

出现相同的字段报错：SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'company_id' in where clause is ambiguous

解决：取别名

$query= MysqlTableName::find()->alias('c');