代表右外部连接,相当于right join
select * from table_a a,table_b b where a.col1 = b.col1(+) ;
1个回答
相关问题
-
sql根据已有的表建新表:create table tab_new as select col1,col2… from
-
select A.a,b,c,d from A,B where A.a=B.a and f='1'
-
select * from table_a a where a.id not in (id1,id2,id3.) 中的i
-
SQL语句理解 select * from B where (select count(1) as num from A
-
delete from A where a_id in (select id from B where b_id in
-
select * from v$locked_object a,user_objects b where a.OBJEC
-
Tom enjoys ________ stamps in his free time. A.collect B.col
-
英语翻译1 everyone ___ hobbies.A have b has c is d can2 ____ col
-
ms sql :select * from (select *from b) as xxx where 和 select
-
where is my key ___________ on the table.a.It maybe b.Maybe