Mysql multi-table joint query returns the content of a table. An error is reported when mysql statements are used today. The statement is as follows: SELECT sapcle FROM SellEnterpriseBaseInfor sebie, SellEnterpriseBaseInforVer sebive, sellapplyperpolicangelist sapcle WHERE 1 = 1 AND sebie. iVerID = sebive. id AND sapcle. iEnterpriseBaseInforID = sebive. id AND sapcle. iState = 1 AND sapcle. iEnterpriseID = 11027516 AND sapcle. id = 84 on the consol console, I found the SQL statement printed by hibernate. When I got the SQL statement from mysql, I always reported an error, prompting Unknown column 'sapcle' in 'field list ', according to the sellapplyperpolicangelist sapcle defined later, it should be okay. I asked my colleagues to find that this can be written in java statements, however, when using the mysql editor, you need to change it to the SQL code SELECT sapcle. * FROM SellEnterpriseBaseInfor sebie, SellEnterpriseBaseInforVer sebive, sellapplyperpolicangelist sapcle HERE 1 = 1 AND sebie. iVerID = sebive. id AND sapcle. iEnterpriseBaseInforID = sebive. id AND sapcle. iState = 1 AND sapcle. iEnterpriseID = 11027516 AND sapcle. id = 84