select * from tableA,tableB
where TableA.A(+)=TableB.A1
and table rownum=1
union
select * from tableA,tableB
where TableA.A(+)=TableB.A1
and table rownum=1
不知道行吗?
排序的问题自己解决
where TableA.A(+)=TableB.A1
and table rownum=1
union
select * from tableA,tableB
where TableA.A(+)=TableB.A1
and table rownum=1
不知道行吗?
排序的问题自己解决
where TableA.A(+)=TableB.A1
and tableA.A=1 order by tableB.D desc,tabelB.E