你自己在第一行的select 后面加上就可以了 select t1.ktaid,t2.endtime from ta t1,(select ktaid,max(endtime) as endtime from tb group by ktaid) t2 where t1.ktaid=t2.ktaid(+)
tb表还有其它字段吗?select t1.*,t2.endtime from ta t1,(select ktaid,max(endtime) as endtime from tb group by ktaid) t2 where t1.ktaid=t2.ktaid(+)
select t1.ktaid,t2.endtime
from ta t1,(select ktaid,max(endtime) as endtime from tb group by ktaid) t2
where t1.ktaid=t2.ktaid(+)
from ta t1,(select ktaid,max(endtime) as endtime from tb group by ktaid) t2
where t1.ktaid=t2.ktaid(+)