select * from table_a a,table_b b where a.col1 = b.col1(+) ;

select * from tab_a inner join tab_b on tab_a.col1 = tab_b.c select * into b from a where 11 select A,B,C,D=(select count(*) from 表 where c=a.a and b=a.b select ** from A where A.id in (select id from B where ****) sql根据已有的表建新表：create table tab_new as select col1,col2… from select distinct A.* from A,B where A.id = B.g_id and A.fwzid select A.a,b,c,d from A,B where A.a=B.a and f='1' SQL语句理解 select * from B where (select count(1) as num from A select count(*) from v$process a,v$session b where a.addr = delete from A where a_id in (select id from B where b_id in sql 中 select * from A left join B on A.id=B.id where A.id=?如 select * from a union select * from b 能详细说下么