How to return the content of a table in mysql multi-table joint query _ MySQL

How does one return bitsCN.com from a table in mysql multi-table joint query?

How does one return the content of a table in mysql multi-table joint query?

An error is reported when mysql statements are used today. The statement is as follows:

SQL code

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, but it should be changed when used in the mysql editor.

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

BitsCN.com