select a.contno,b.edorno,
(select bankaccno
from (select *
from ljapay
where ljapay.incomeno = a.contno
order by ljapay.confdate desc)
where rownum = 1)
from lccont a ,lpedoritem b
where a.contno = b.contno
执行后bankno值被固定了,没有关联上表,
a.contno好像是没有传进去
(select bankaccno
from (select *
from ljapay
where ljapay.incomeno = a.contno
order by ljapay.confdate desc)
where rownum = 1)
from lccont a ,lpedoritem b
where a.contno = b.contno
执行后bankno值被固定了,没有关联上表,
a.contno好像是没有传进去
(select bankaccno from ljapay
where rownum=1 and ljapay.incomeno = a.contno and confdate=(select min(confdate) from ljapay where ljapay.incomeno=a.contno)
from lccont a ,lpedoritem b
where a.contno = b.contno
select min(confdate) from ljapay where ljapay.incomeno=a.contno。ljapay.incomeno=a.contno关联不上,
a.contno没有传进去,不知道是不是嵌套太深了的缘故,如果是两层的话可以查出来。