Error code: 1054 Unknown column ' T.createusrid ' in ' group statement '

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: 1054Unknown column ' T.createusrid ' in ' group statement ' implementation time   : 0 sec transfer Time   : 0 sec Total Time      : 0 sec

2. Cause of error

When the SQL statement is grouped, the field is not recognized due to carelessness, which causes the field to be unrecognized (that is, it does not exist in the table), resulting in an error; The database table has a field name of Createuserid, and the Createusrid is written after group by.

3. Solutions

Change GROUP by after field name to group by T.createuserid

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Error code: 1054 Unknown column ' T.createusrid ' in ' group statement '