a,b表 a.id=b.id(+)的意思
解决方案 »
- EXP-00056: 遇到 ORACLE 错误 12170导出数据库遇到错误,新手,希望遇到大神指点。
- ORACLE表修改
- 数据库表被锁死的原因
- 链接数据库的时候抛出异常
- 只要以administrator身份登录计算机,不用用户名和密码就能登录ORACLE。
- 使用OCI调用存储过程有时无法将参数传入,那位虾给个解释!
- 如何知道我的SQLPLUS里面的SESSION设置
- sql . about group by
- 急急!下面的oracle错误如何解决??????
- 分区 支持SUBSTR么
- ORA-01460: unimplemented or unreasonable conversion requested
- 大家好,请大家帮我看一下这个触发器错在哪里?
select a.id,a.name,b.address from a,b
where a.id=b.id(+)
右联:
select a.id,a.name,b.address from a,b
where a.id(+)=b.id
外联
SELECT a.id,a.name,b.address
FROM a,b
WHERE a.id = b.id(+)
UNION
SELECT b.id,'' name,b.address
FROM b
WHERE NOT EXISTS (
SELECT * FROM a
WHERE a.id = b.id);
在9i以上,已经开始支持SQL99标准,所以,以上语句可以写成:
默认内部联结:
select a.id,a.name,b.address,c.subject
from (a inner join b on a.id=b.id)
inner join c on b.name = c.name
where other_clause
左联
select a.id,a.name,b.address
from a left outer join b on a.id=b.id
where other_clause
右联
select a.id,a.name,b.address
from a right outer join b on a.id=b.id
where other_clause
外联
select a.id,a.name,b.address
from a full outer join b on a.id=b.id
where other_clause
or
select a.id,a.name,b.address
from a full outer join b using (id)
where other_clause