select * from table_a a,table_b b where a.col1 = b.col1(+) ;
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:英语作业 时间:2024/07/13 00:27:59
select * from table_a a,table_b b where a.col1 = b.col1(+) ;最后的(+)怎么解释?
![select * from table_a a,table_b b where a.col1 = b.col1(+) ;](/uploads/image/z/19518395-59-5.jpg?t=select+%2A+from+table_a+a%2Ctable_b+b+where+a.col1+%3D+b.col1%28%2B%29+%3B)
代表右外部连接,相当于right join
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 能详细说下么