select * from A,B,C where A.a=B.b and A.a=C.c;
select * from Aleft join B on A.a = B.bleft join C on A.a = C.c
select * from a,b,c where a.a=b.b and a.a=c.c;