select code from tb where tb.time >
(select nvl(max(tb2.time),to_date('01-JAN-1901','DD-MON-YYYY') from tb2 where tb2.code = tb1.code)
(select nvl(max(tb2.time),to_date('01-JAN-1901','DD-MON-YYYY') from tb2 where tb2.code = tb1.code)
是不是用
select code from tb where tb.time >
(select nvl(max(tb2.time),'0') from tb2 where tb2.code = tb1.code)
就可?
(select max(tb2.time) from tb2 where tb2.code(+) = tb1.code)