Today, when using the MySQL statement is always the error, the statement is as follows:
SQL code
Copy Code code as follows:
SELECT sapcle from sellenterprisebaseinfor sebie,sellenterprisebaseinforver sebive,sellapplypermitchangelist sapcle
WHERE 1=1 and Sebie.iverid = Sebive.id and Sapcle.ienterprisebaseinforid=sebive.id and sapcle.istate=1 and Sapcle.iEnterp riseid=11027516 and sapcle.id=84
In the Consol console, query to hibernate print out of the SQL statement, get MySQL inside query always error, prompt unknown column ' sapcle ' field list ', according to the following definition Sellapplypermitchangelist sapcle should have no problem, asked colleagues to find that in the Java statement can be so written, but in the MySQL editor inside the use of the time to change to
SQL code
Copy Code code as follows:
SELECT sapcle.* from Sellenterprisebaseinfor Sebie, Sellenterprisebaseinforver sebive,sellapplypermitchangelist sapcle
here 1=1 and Sebie.iverid = sebive.id. Ienterprisebaseinforid=sebive.id and Sapcle.istate=1 and sapcle.ienterpriseid=11027516 and sapcle.id=84