SQL查询语句错误SELECTarticleidFROM(SELECTarticleidFROMarticleaWHEREa.articleida.farticleid)报错报
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
需要加一个别名，这是ｓｑｌ的格式，随便起个名字就行