求助，大神帮看下这段有什么语法问题

[Bohroo]

SELECT
c5t.MODEL,
c5t.FACTORY,
cbt.*, cct. NAME categoryname,
COUNT(1) AS num
FROM
ci_host_t c5t,
ci_base_t cbt,
ci_category_t cct
WHERE
c5t.ci_id = cbt.ID
AND cct.ID = cbt.CATEGORYID
AND cct.`CODE` IN (
'HOST',
'PCSERVER',
'MINICOMPUTER',
'WORKSTATION',
'BLADESERVER'
)
GROUP BY
c5t.MODEL,
c5t.FACTORY,
cbt.*, cct. NAME categoryname


总是提示语法有错误，找不出来啊..

[ACMAIN_CHM]

错误信息是什么？

[道玄希言]

cct. NAME categoryname 是这里错误吧, 你 cct.后边, 怎么搞出一个空格出来了啊.... 去掉两处 cct. NAME 空格试试

[Bohroo]

引用 1 楼 ACMAIN_CHM 的回复:

错误信息是什么？

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*, cct. NAME categoryname' at line 23

[Bohroo]

引用 2 楼 yangb0803 的回复:

cct. NAME categoryname 是这里错误吧, 你 cct.后边, 怎么搞出一个空格出来了啊.... 去掉两处 cct. NAME 空格试试

貌似和空格没关系，它自动美化的..

[道玄希言]

SELECT 
c5t.MODEL, c5t.FACTORY, 
cct.name,
COUNT(1) AS num,

cbt.*

FROM
ci_host_t AS c5t
INNER JOIN ci_base_t AS cbt
ON c5t.ci_id = cbt.ID
INNER JOIN ci_category_t AS cct
ON cbt.CATEGORYID = cct.ID
WHERE
cct.`code` IN (
'HOST',
'PCSERVER',
'MINICOMPUTER',
'WORKSTATION',
'BLADESERVER'
)
GROUP BY
c5t.MODEL,
c5t.FACTORY,
cct.name,  
cbt.CATEGORYID, cbt.ID 

GROUP BY 条件里面不能用* 来偷懒, 我调试用字段时, 通过, * 号错误.

[Bohroo]

引用 5 楼 yangb0803 的回复:

SELECT 
c5t.MODEL, c5t.FACTORY, 
cct.name,
COUNT(1) AS num,

cbt.*

FROM
ci_host_t AS c5t
INNER JOIN ci_base_t AS cbt
ON c5t.ci_id = cbt.ID
INNER JOIN ci_category_t AS cct
ON cbt.CATEGORYID = cct.ID
WHERE
cct.`code` IN (
'HOST',
'PCSERVER',
'MINICOMPUTER',
'WORKSTATION',
'BLADESERVER'
)
GROUP BY
c5t.MODEL,
c5t.FACTORY,
cct.name,  
cbt.CATEGORYID, cbt.ID 

GROUP BY 条件里面不能用* 来偷懒, 我调试用字段时, 通过, * 号错误.

明白了，果真如此，非常感谢！