SQL查询语句错误
SELECT articleid FROM (SELECT articleid FROM article a WHERE a.articleid=a.farticleid)
报错报
第 1 行: ') ' 附近有语法错误。
哪里错了
------解决方案--------------------SELECT articleid FROM (SELECT articleid FROM article a WHERE a.articleid=a.farticleid) as t
------解决方案--------------------SELECT articleid FROM (SELECT articleid FROM article a WHERE a.articleid=a.farticleid) t
需要加一个别名,这是sql的格式,随便起个名字就行