17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT A.ID,A.NAME||B.NAME AS NAME FROM T_A A JOIN T_B B ON A.ID=B.ID
okselect t1.rn, t1.name || t2.name
from (select rownum rn, t1.name from t1 where rownum < 5) t1,
(select rownum rn, t2.name from t2 where rownum < 5) t2
where t1.rn = t2.rn
[/quote]
为什么要写的这么麻烦啊
这样:
select t1.no, t1.name||t2.name from t1,t2 where t1.no=t2.no;不是很简单吗SELECT A.ID,A.NAME||B.NAME AS NAME FROM T_A A JOIN T_B B ON A.ID=B.ID
两个表join下,合并字符串就好select t1.rn, t1.name || t2.name
from (select rownum rn, t1.name from t1 where rownum < 5) t1,
(select rownum rn, t2.name from t2 where rownum < 5) t2
where t1.rn = t2.rn
[/quote]额 楼主说了 表没有关联的、[/quote]
自己查个行号当关联,多套一层而已。select t1.rn, t1.name || t2.name
from (select rownum rn, t1.name from t1 where rownum < 5) t1,
(select rownum rn, t2.name from t2 where rownum < 5) t2
where t1.rn = t2.rn
[/quote]额 楼主说了 表没有关联的、select t1.rn, t1.name || t2.name
from (select rownum rn, t1.name from t1 where rownum < 5) t1,
(select rownum rn, t2.name from t2 where rownum < 5) t2
where t1.rn = t2.rn