corresponds to your mysql server version_MYSQL查询报错checkthemanualthatcorrespondstoyourMySQLserververs...

MYSQL查询报错

check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 32

----------------------------------------------------------------------下面是查询语句

select a.cat_Serial as cat_one ,

a.cat_name as catone,

b.cat_Serial as cat_two ,

b.cat_name as cattwo,

c.cat_serial as cat_three,

c.cat_name as catthree ,

d.cat_serial as cat_four ,

d.cat_name as catfour ,

e.cat_serial as cat_five ,

e.cat_name as catfive ,

f.cat_serial as cat_six ,

f.cat_name as catsix ,

g.cat_serial as cat_seven ,

g.cat_name as catseven ,

h.cat_serial as cat_eight,

h.cat_name as cateight

from imall_category_one a

left join imall_category_two b

left join imall_category_three c

left join imall_category_four d

left join imall_category_five e

left join imall_category_six f

left join imall_category_seven g

left join imall_category_eight h

on

a.cat_Serial=b.parent_id

and b.cat_Serial=c.parent_id

and c.cat_serial=d.parent_id

and d.cat_serial=e.parent_id

and e.cat_serial=f.parent_id

and f.cat_serial=g.parent_id

and g.cat_serial=h.parent_id

作业帮用户2017-05-10举报