Error code: 1054 Unknown column & #39; t. createUsrId & #39; in & #39; group statement & #39;, 1054t. createusrid

Error code: 1054 Unknown column't. createUsrId 'in 'group statement', 1054t. createusrid

1. Error description

1 queries executed, 0 success, 1 errors, 0 warnings query: select count (t. id), t. 'createuserid' from t_acs_ints t where t. id not in (SELECT t1.ionId FROM t_acs_cont t1, t_ac... error code: 1054 Unknown column't. createUsrId 'in 'group statement 'execution time: 0 sec Transfer Time: 0 sec total time consumed: 0 sec

2. Error cause

When grouping SQL statements, this field cannot be identified (that is, it does not exist in the table) due to carelessness, resulting in an error. The field name of the database table is createUserId, after group by, it is written as createUsrId.

3. Solution

Change the field name after group by to group by t. createUserId.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.