select a1.name,
a2.name,
b.name
from b,a a1,a a2
where b.id1=a1.id(+)
and b.id2=a2.id(+)
a2.name,
b.name
from b,a a1,a a2
where b.id1=a1.id(+)
and b.id2=a2.id(+)
解决方案 »
- oracle 德文处理
- 执行sql语句时,报如下错误,寻求解决办法
- randomize 的速度问题,请教
- 求助 只用SQL 能实现这个查询吗
- Could we alter the database to an 'backup status' and then copy the datafiles ,logfiles and controlfiles by OS copy?
- 如何取得当前时间前10个小时的值,这样的SQL文怎样写
- 新手求助IMP导入数据的问题
- 普通身份的用户,如何用SQL语句查出一张表中某一个字段的类型?
- 在线等待!急!!!!!!!!!!!!!!!!!!!!!
- odbc的数据源驱动程序是调用oracle中的那个dll文件?
- (急)请问用什么软件生成Oracle的SQL数据查询的最好用,谢谢!
- sql語句,請教......
---------- ----------
1 a
2 bSQL> select * from b;ID1 ID2 NAME
---------- ---------- ----------
1 2 haha
SQL> select (select a.name from a,b where a.id=b.id1),
2 (select a.name from a,b where a.id=b.id2),name from b;(SELECTA.N (SELECTA.N NAME
---------- ---------- ----------
a b haha
select c1.a_name,c2.a_name,b.b_name
from
(select a.name a_name,b.name b_name
from a,b
where a.id=b.id1) c1,
(select a.name a_name,b.name b_name
from a,b
where a.id=b.id2) c2
where c1.b_name=c2.b_name
--------- ----------
1 a
2 b
3 cSQL> select * from b; ID1 ID2 NAME
--------- --------- ----------
1 2 hahaSQL> select a.name,c.name,b.name from a,a c,b where a.id=b.id1 and c.id=b.id2;NAME NAME NAME
---------- ---------- ----------
a b haha