MYSQL查询报错checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear''atline32----------------------------------------------------------------------下面是查询语句selecta.catSerialascatone,a

Question

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

Answer 1

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 1=1
and a.cat_Serial=b.parent_id
left join imall_category_three c 1=1
and b.cat_Serial=c.parent_id
left join imall_category_four d 1=1
and c.cat_serial=d.parent_id
left join imall_category_five e 1=1
and d.cat_serial=e.parent_id
left join imall_category_six f 1=1
and e.cat_serial=f.parent_id
left join imall_category_seven g 1=1
and f.cat_serial=g.parent_id
left join imall_category_eight h 1=1
and g.cat_serial=h.parent_id
on