Question

ORACLE中如何多表关联查询。如有A、B、C三张表，A表字段a和B表字段b以及C表字段c关联，写出查询语句

Answer 1

select * from A,B,C where A.a=B.b and A.a=C.c;

Answer 2

select * from A
left join B on A.a = B.b
left join C on A.a = C.c

Answer 3

select * from a,b,c where a.a=b.b and a.a=c.c;