呵呵,开始我试过了,直接报错。。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 '.a1 from A,B limit 0,2' at line 1SELECT A.A1 as a.a1,B.B1 as b.b1 FROM A,B,就这句SQL,报.a1出错。
SELECT A.A1 as 'a.a1',B.B1 as 'b.b1' FROM A,B 家别名 你那个。号应该是不认识所以报错
家别名 你那个。号应该是不认识所以报错