Find a simple SQL query statement SQLcodeselectcp. *, cpsmallclass. shunxuascpsmallclass. classorderfromcpleftjoincpsmallclassoncp. smallclassid = cpsmallclass. sm find a simple SQL query statement
SQL code
Select cp. *, cpsmallclass. shunxu as cpsmallclass. classorder from cp left join cpsmallclass on cp. smallclassid = cpsmallclass. smallclassid order by cpsmallclass. classorder
This is an SQL query. the shunxu field of cpsmallclass is queried from the cpsmallclass table and added to the cp table. Then, sort by the shunxu field in cpsmallclass. However, because the cp table also contains the shunxu field, a new name is named classorder.
What should I do? Always reported errors.
------ Solution --------------------
Try this way:
Select cp. *, cpsmallclass. shunxu as cpsmallclass_classorder from cp left join cpsmallclass on cp. smallclassid = cpsmallclass. smallclassid order by cpsmallclass. classorder
------ Solution --------------------
Cpsmallclass. shunxu as cpsmallclass. classorder
Change
Cpsmallclass. shunxu as classorder
