I used to code my joins under the old Oracle standard way, eg.
where table_A.column1 = tableB.column1
but now I'm switching to the ANSI standard, eg.
inner join table_B on table_B.column1 = table_A.column1
the problem I'm having is attempting an outer join (using ANSI) on a subquery.
left outer join table_B on table_B.column1 = table_A.column1
left outer join table_C on table_C.column2 = table_A.column2
and table_C.date = (select max(date)
where table_D.column3 = '1'
where table_A.column4 = 'New'
can somebody give me a hand on to properly write this query in ANSI standard kinda way?