错在哪里：SELECT ainfo.aid ,ainfo.atitle,2info.atitle FROM ainfo,2info where ainfo.atitle=2info.atitle AND ainfo.atitle='1'

Question

try:
SELECT ainfo.aid ,ainfo.atitle,2info.atitle FROM ainfo inner join 2info on ainfo.atitle=2info.atitle where ainfo.atitle='hisun'

Answer 1

To: dbase(熊猫眼) 
  在页面中报告了一个和这无关的错误（说ExecuteReader错误）；在sql查询分析器中报告“.”附近有错

Answer 2

2info.atitle ,你里,你的点不是半角的,就是说可能是在中文状态下写的,你改一下

Answer 3

SELECT ainfo.aid ,ainfo.atitle,
[2info].atitle FROM ainfo,[2info] where ainfo.atitle=[2info].atitle AND ainfo.atitle='hisun'

Answer 4

SELECT ainfo.aid ,ainfo.atitle,[2info].atitle 
FROM ainfo,[2info]
where ainfo.atitle=[2info].atitle AND ainfo.atitle='hisun'谁让你用数字开头作为表名的！下次记住不要这样了