建立索引会快点CREATE INDEX aid ON A (id);CREATE INDEX bid ON A (id);select A.a1,A.a2,B.b1 from A ,B where A.id=B.id;
