Case Statement in Oracle with multiple like conditions and one single column as resul

[srikant1990]

I just need to print or get the max display date from table b using table a with left outer join

[Luuk]

ok, and what is your problem with that?

SELECT MAX(display_dat e)
FROM b
LEFT JOIN a ON 1=1;