Min in left outer join condition

Hi everybody,

I'm trying to use MIN in on condition of left outer join in abap , but it's faield;is it possible in abap?

SELECT t1.foo, t2.bar
  FROM table1 AS t1
LEFT OUTER
  JOIN table2 AS t2
    ON t2.table1_id = t1.id  
   AND t2.datefld = 
       ( SELECT MIN(datefld)
           FROM table2
          WHERE table1_id = t1.id )

thanks !