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

2024-11-17 20:19:18
推荐回答(3个)
回答1:

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

回答2:

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

回答3:

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