select sfb01,(select ecm311 from (select * from sz028.ecm_file where ecm01=sfb01 order by ta_ecm03 desc ,ecm03 desc) where rownum=1)
from sz028.sfb_file
这种类型的sql怎么写才能正确，现在这个写法 报作为查询条件那个sfb01无效
select a.sfb01,a.ecm311
from sz028.ecm_file a
left join sz028.sfb_file b
on a.ecm01 = b.sfb01
这样？你写的那是啥呀...我在猜你的意图
select sfb01,(select ecm311 from (select * from sz028.ecm_file where ecm01=sfb01 order by ta_ecm03 desc ,ecm03 desc) where rownum=1) as ecm311
from sz028.sfb_file
有两个问题，
1. 子查询中不能 order by
2. 标量子查询，查询结果应该只有一个值，你的查询可能会有多个值